Best Of
Re: SOC2 Result
Hi
if you visit this page there is a link to request a copy of the latest SOC2 report:
Does that help?
KPH
Re: Dynamic View - details panel
Hey @jeanniesry_4,
Do any of those fields meet the following criteria in your source sheet:
- Field is from a System Column
- Field is from a Gantt End Date Column
- Field is the "End date column" in the date range display of the project settings
- Field is from a Gantt Predecessor Column
- Cell in source sheet contains a formula
- Cell in source sheet contains an inbound cell-link
- Cell in source sheet contains a Hyperlink
If any of those conditions above met the criteria, then this may be the root cause.
Ash A.
Re: Chart Widget help
Hi @Eenmeier
For Charts to pull from a Report, both Grouping and Summary need to be applied. In your case, since you only need the one Summary, you'll need to add a field across your sheets with the same value so you can create a "group" with a constant value that the Report can use.
You'll end up with a double header row in the Report - one as an overall total, and one as the Grouped total with the Summary that the chart can use. Let me know if this works for you and makes sense! Here's more information: New! Create a chart from reports with grouping and summary
Cheers,
Genevieve
Genevieve P.
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