-
Flag Trigger Formula
I am trying to create a formula to trigger a red flag based on two variables: a date column and a drop down task column. Here is the formula that I have created. What syntax do I use to look for an empty cell represented here with an "X"? =IF(AND([Contact Date]1 =TODAY, [Contact Results]1 = X)
-
Sending notifications, regularly, say every Monday
I somewhat remember to read in the community that this is not supported, but want to confirm. I'd like to send a notification to people who are shared a sheet, regularly, say every Monday. How do I do it? No condition to set, simply every Monday (for example). Thanks for your advice!
-
Approvals, Updates and Deleting Attachment in a Webform during Update
HI there. I am only a month old Smartsheet user and currently under the Business Plan. i am building the New Hire Request Form for our company and I came across with problem in the multiple approval as well as the things to do before a request will be approved. When the requestor filled up the request form, it will prompt…
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
Update Form not allowing updates to columns with formulas
I have a sheet that have formulas in some columns and when the update request goes to the user the user does not have the ability to update those columns. Is this a known issue and can this be changed to allow updates to columns with formulas. See attached.
-
Filter based update requests
Hello dear Smartsheet staff, I noticed discussions about update requests, some concern single or multiple rows, others concern columns or the whole sheet. Could it be possible to implement FILTER-BASED update requests? I guess that would satisfy everybody's needs. Best,
-
Alert and Action Update Request
I thought an "automated" (Alert and Actions) Update Request can be built to produce a form on the recipients end. That's working for me per a "manual" Update request as in image one below. But per the Alert and Actions Update Request my recipients are only getting row data/information in their email. No link to a form.…
-
Should I use a Report or a formula?
I have users completing a form to update a source sheet I use for a Dashboard. Once the sourcesheet is updated I would like to show the latest update in realtime with having to update the dashboard manually. Is this possible? If so what would I need to do? Could I use a report or a formula.
-
Pin sheets to top of workspace
Hello, I have a Workspace that will soon have several dozen sheets or more. I have a Template for this Workspace and a Smartsheet on how to use the Workspace for my organization. It is going to get very easy for these two important sheets to get lost. Is there a way I can "Pin" them to the top of the list?
-
Checking box via mail
Hello, is there an option to make the check box "checkable" via mail update form? I have a column "Task accepted" and I would like to enable people to check that they accepted task via mail when they receive an update. I see that the checkbox is sent as image so I am wondering if there is a such option ( See attached…
