Best Of
Re: Forms
If you use a form rather than an update request automation, you have the option to add a field label. So your column name could be very short (Question1, for example) and the label would be the full question.
Does this help? If not, can you provide some more details about what you are trying to do? A screenshot of your form and the error would be great.
KPH
Re: Is there a way to count the number of attachments in a row?
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!
Andrée Starå
Re: Is there a way to attach an uploaded photo(s) to a specific column instead of the whole row?
I actually find it easier to add photos on a mobile. They can just click into the field on the mobile app form, take the photo or open their photos, and save. The photo will appear in the cell on the sheet.
KPH
Re: Help with WEEKNUMBER formula
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
Kelly Moore
Re: Report doesn't show data for others
@Xochitl C. Hi, most likely they are not shared to the underlying sheet(s) used to populate the report. If you do not want to share the sheets then publish the report or display it in a dashboard.
Razetto
Re: Conditional/customized formulized data validation
Happy to help!
Unfortunately, it's not possible now, but it's an excellent idea!
Possible workarounds
- Using a form, and so-called helper columns, If project a, show column 1, b, show 2...
- Using conditional formatting and messaging in the sheet + helper columns. If project a, highlight and show message for column 1, b, show 2...
Make sense?
Would any of those options work/help?
✅Remember! 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!
Andrée Starå
Re: Indexing and collecting information from non adjacent columns in original sheet
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
Kelly Moore
Re: Allow Forms to be Saved to a Workspace
This would also help to copy the basics of a form as well when using the same setup for different sheets or workspaces.
Stephanie Graham
Re: Use a formula for subtraction between two columns
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!
Ker9