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.)
This discussion was created from comments split from: How do I combine multiple INDEX Collect formulas in one Formular?.
I'm need to apply a function to average a column (answer is correct (8)) if the other column (The nurse is caring for a a patient who dove into a) is NOT blank. I copied this over from an excel spreadsheet. I would like to keep the average in the top row. Right now it's saying "#unparseable" as the formula is not the same…
So here is my current formula… =COUNTIFS({Date Completed}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Staff name}, =Staff@row ) This works. It gives me a number for all observations submitted in the month. The problem is it also counts the month for the previous year. How do i filter the count by month and year? Thank…
