Sign in to join the conversation:
Based on my attached images, I am looking for a formula that will auto fill my Start Date when my Project Stage = "Scheduled" and populate Finish Date when Project Stage = "Invoiced". Any help will greatly be appreciated. Thanks.
I keep circular reference error when I try the following Formula:
=IF([PROJECT STAGE]238 = "Scheduled", [START DATE]238, MONTH(@cell) = MONTH(TODAY()))
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?
I have a column named Territory, where I am trying to write a formula to populate it when names are chosen from an adjacent drop-down list column called Employee Attendee. If more than one name is selected from the Employee column, I would like their respective territories to populate in the Territory field, separated by a…
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],…
