我am trying to count anything that is due this week. I have a due date column in my smartsheet, but what is the best way to count this information?
我am having an issue with VLOOKUP. I will attempt to explain. When I set up the parameters to "reference another sheet" I capture all of the row/columns through the end of the sheet. As I add new rows to the source/reference sheet and my main sheet the VLOOKUP does not return the expected values. When I look at the…
Hello Everyone. The projects I handle are the same each time in terms of the tasks to carry out. but they can differ in duration based on the 'size' of the work... I am using a standard sheet template which I also use to forecast, I would like to change the 'duration' of a set of tasks based on a dropdown that would return…
我wonder if anyone would be able to help me. I am trying to collate some data that allows me to give a count of a number of jobs that have missed a target date. The sheet I am working on also has 2 different cost centres and I would like to break this data down so that I can see the data for each cost centre. I have…
how do i build a formula that gives me the actual date for today + 35 working days?
Hello all - first time poster I am trying to get the difference between two dates by using the NETWORKDAY formula and I am having an issue. I have 2 date field columns - an assignment date and a go-live date - and I am trying to find the difference in business days between the two. I have successfully run the formula to…
我'm trying to check a box to indicate whether a remediation item has been opened or closed in the past year. My relevant fields are report date, target date, and date closed. Date Closed could potentially be blank. Here is the formula I've been trying to refine: =IF(OR(TODAY() - [Report Date]77 < 365, TODAY() - [Last Remed…
我新发布的社区。我have looked through previous posts but cannot find anything similar to what I am trying to do. I am trying to nest a LOOKUP formula. My current (working) formula is: =LOOKUP("In Progress", [Progress Should Be]74:[Unit Number]154, 4, true) There are three possible values in the…
Hello, I have these columns on a sheet: Expected Return Date (date) Actual Return Date (date) Media Manager (contact) How do I send an email to the Media Manager if the Expected Return Date has passed? "If today is greater than Expected Return Date and Actual Return Date is blank, send notification to Media Manager"…
Hello - - I am trying to count the number rows in a column that do not have strikethrough applied to them. Is there anyway to use a formula to determine if a cell value has been formatted with strikethrough? Thanks,
