I have a simple math equation in one of my cells, and in place of one of the numbers I would like to reference a count of cells with dates in them in a certain column. My equation is: =100 - (((60 / 4…
I have a project where Activity A is anticipated to run for a month. And Activity B starts around the same time, maybe a little later (start date is independent of A).. however B can NOT be closed out…
Hi Guys I am trying to calculate instances whereby: Status Column = "Scheduled" AND Date Column = date range One of my attempts is shown in the screenshot below, I have tried a few tweeks but can't se…
Hi, I'm trying to return a status within a range when the finish date is within 7 days, I've tried a few alternatives with the latest below (using @cell) which I know isn't correct but I'm hoping I'm …
Is there a way to count past due tasks in Smartsheet? I would prefer to count based off of the finish date, but cannot seem to get the formula to work. I am fairly new with the software, so any recomm…
I'm new to Smartsheets and I'm trying to figure out how to do an IF([Response]3="Yes", VLookup formula linked to a reference data sheet. I've tried various ways to input and always get Unparseable. An…
Hi, I'm wondering if it's possible to reference a cell in a different sheet with a formula. My source sheet is intended for users to add entries, and my destination sheet is intended to keep track of …
Is there a trick to referencing % Percentages)when using the If function, automating the RYG symbols in a Symbol column? I have a simple IF formula referencing cell formatted to %. When I replace the …
Hi There. I have a sheet, very much like a project tracking sheet, with a few adjustments. I have a start date / due date / completion date, as well as a status column. I would like to create a column…