Sign in to join the conversation:
Hi All
has anyone successfully made a risk assessment template within smartsheet ?
Im not able to get normal excel formulae to work ( also the templates posted on smartsheet dont work )
appreciate if you could share template with me
Marie
Hi Marie,
Try reaching out to our Support team to see if they have a Smartsheet version of the risk assessment template. (I know sometimes they have those templates available to them.)
I have a counting formula that's working in Sheet1. When I try to use that same formula in Sheet2 to pull the data from Sheet1, I get an UNPARSABLE error. What am I doing wrong? Original formula (in Sheet1): =COUNT(DISTINCT(COLLECT([Department]:[Department], [StartDate]:[StartDate], >=DATE(2025, 7, 1), [Status]:[Status],…
I’m looking for a cross-sheet formula in Smartsheet to calculate the average Turn Around Time (TAT) by specific Site Numbers. Source sheet details: Site Number (text/number) Turn Around Time (number; measured in days) Target sheet details: I have a row per site and want a formula in the Avg TAT column that returns the…
Hi All, I am trying to create a formula to work out the number of days ( Helper V1 ) between the VISIT 1 and VISIT 2 days column. Any thoughts would be greatly appreciated Thanks