Sign in to join the conversation:
HI, If a checkbox is selected in column "SNAGS" can another column "DATE RECORDED" automatically populate the date in which the checkbox field was selected?RegardsStuart
Try this:
=IF(SNAGS1 = true, TODAY(), "")
If you uncheck the box, the date will be cleared.
Unfortunately, that won't probably work because the TODAY will update to the present day.
The only way that I can see that it would work will be if you change the date manually to the date on that day.
Best,
Andrée
Hi again Stuart,
It's possible to set up with the help of a service like Zapier, Azuqua or similar. Depending on your specific use case the question is if it's worth it.
I hope this helps you!
Andrée Starå
Workflow Consultant @ Get Done Consulting
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…
