Best Of
Re: Formula to remove the 'd' from "Days Needed" rollup number relinked into my summary Sheet?
@ubaidxawann and @George Belly Yes. The VALUE/SUBSTITUTE method works well based on previous comments. You can also use the @cell reference within the SUBSTITUTE function that is nested in the COUNTIFS to avoid the helper column as outlined previously.
Paul Newcome
Re: Helping Users Understand How Data Flows
We will use video recordings for FAQs so that if we get the question we can just direct the user to the video that explains it nice and clearly.
Then, you can put those videos into a Smartsheet "Help Dashboard" that users can get into the habit of checking first.
Re: How to best track Outstanding Update Requests
As promised, video showing using a form to update an existing form is below!
To answer your questions
- Correct, PM can send an email with a checkbox and an automate has a link to the update form.
- A Dynamic View is NOT needed for this solution
- You can have the form look however you want, within the features of Smartsheet forms. Example, you could have helper text and require specific fields to be filled out
- Yes, You can track the date when the form was sent, and then when the associated response was received (or if it hasn't been received yet). Using some date columns and logic, you can easily see when a form was sent, the last time one was sent to a specific recipient, etc.
Video showing the simplified flow, without using automation. You'll get the idea though.
Darren Mullen
Re: Automation Email Alert Issue - Grouping Notifications with Unique Subjects
This is a big issue for us and it would be great to see it resolved.
We have had a few emails going to a client with the subject line as described by @admin_smartsheet_lpc and is really not acceptable for our use case.
In the meantime we have implemented @admin_smartsheet_lpc 's clever work around, but it's time consuming and not quite up to the standards one would hope to expect from Smartsheet.
AliceVBH
Re: Schedule Form Deactivation & Friendly Form Ended Msg
I use a date field in my form that is hidden and has a default value of the date that I want to "deactivate" my form on. I also include a header field in the form that has the deactivation message. Then I use conditional logic to say that if the date field is after today, show all of the fields I want shown, and a second bit of logic to say that if the date is before today (meaning in the past), it will only show the deactivation header.
Since it is showing only a header field, no other field can be filled in which means the Submit button just won't work.
Paul Newcome
Re: Form Option to Rank Drop Down Choices
Couldn't you set each field as a dropdown and then use the radio buttons in the form?
Paul Newcome
Re: Calculate percentage based on drop down response from one cell and value of another cell
My apologies. I forgot to work in the occupied / vacant piece.
=SUMIFS(CHILDREN([Sq Ft.]@row), CHILDREN([Occupied/Vacant]@row), @cell = "Occupied") / [Sq Ft.]@row
Paul Newcome
Re: Calculate percentage based on drop down response from one cell and value of another cell
It's working beautifully now, thank you!
Re: Quickly delete Sheet Summary
Feel free to revisit if you need help getting it set up. My instructions were pretty high-level, so if more detail is needed, just let me know.
Paul Newcome

