Sign in to join the conversation:
Hello,
I would like to create a column that tells me how many days since the last comment. Is there a way to do this?
You could try to use an auto column type to track last Modified Date on the row and then run a formula off of it to count days. But "Modified Date" will update any time any cell on the row is updated, not just a comment.
Hi,
It could probably be set up with the help of a third-party solution like Zapier or similar.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hello, I am stumped again. I am looking to average data from another sheet and am getting a #Divide by Zero error, even though I believe the formula is written to ignore zeros and blanks in the data. What am I missing? =AVG(COLLECT({Indirect Project Summary -Avg Leadtime}, {Indirect Project Summary - Executive Sponsor},…
Hi all. I am working with a sheet trying to get what - I thought - would be a simple average, but the formula seems to be returning the incorrect value. I am trying to get an average of the temperature in a column if the created date (created date is the Smartsheet default column) is equal to yesterday: Which I would…
Hi everyone, I’m trying to automatically change the Status to red once the deadline is reached. I placed the following formula directly in the Status column: =IF([Ende]@row <= TODAY(), "Red", [Status]@row ) However, I keep getting the error #CIRCULAR REFERENCE. My understanding is that this happens because the formula is…
