Best Of

Hi @Xochitl C.

I hope you're well and safe!

You could add a field in the form where they have to select the number of attachments.

Also, you can add a workflow that counts each time an attachment is added to the row, but it can't count the number of attachments added on one occasion.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Hello @Xochitl C.

I'm happy to help. To help me clarify - were you expecting the formula above to produce the combined week number and month text string, or was that formula meant to do something else?

To produce the combined text, try this. As written below, it will produce WK 1 JAN2024, which might be needed if your sheet will span multiple years

="WK" + " " + WEEKNUMBER([Audit Submission Date]@row) + " " + IF(MONTH([Audit Submission Date]@row) = 1, "JAN", IF(MONTH([Audit Submission Date]@row) = 2, "FEB", IF(MONTH([Audit Submission Date]@row) = 3, "MAR", IF(MONTH([Audit Submission Date]@row) = 4, "APR", IF(MONTH([Audit Submission Date]@row) = 5, "MAY", IF(MONTH([Audit Submission Date]@row) = 6, "JUN", IF(MONTH([Audit Submission Date]@row) = 7, "JUL", IF(MONTH([Audit Submission Date]@row) = 8, "AUG", IF(MONTH([Audit Submission Date]@row) = 9, "SEP", IF(MONTH([Audit Submission Date]@row) = 10, "OCT", IF(MONTH([Audit Submission Date]@row) = 11, "NOV", IF(MONTH([Audit Submission Date]@row) = 12, "DEC")))))))))))) + YEAR([Audit Submission Date]@row)

If you to not need the year as part of the textstring, delete the bold text from the formula above.

Will this work for you?

Kelly

Hey @Rachael Stammers

So glad you got it working.

As you continue to grow your formulas, consider the good practice of renaming the generically assigned cross sheet reference names from smartsheet. For instance, instead of 3. Safety Investigation Range 7, you can rename the Range 7 before you click the insert reference button to reflect the name of your actual column. This will help you troubleshoot your formulas as you can see by the range name more clearly in the text.

Let me know if there's anything else I can do for you

Kelly

@jmhoward

Hi @Megan.elh

Please see if this returns the value you expect:

=[Contract value]@row - [Current spend]@row

Column names that contain spaces must be entered in square brackets. Smartsheet will do that for you when you type the equal sign, then select the first cell of the equation, type the minus sign, and select the next cell.

Entered on the row you wish to calculate. It can be converted to a column formula by right clicking the cell and selecting "Convert to Column Formula".

Hope this helps!

Ok. Set up two separate automations. The first one will lock the rows at 1am and the second will unlock the rows at 2am. The lock/unlock should update the TODAY function without you having to manually activate the sheet.