-
Calculating a date 45 days from Start Date
I have a sheet that has a Start Date that is called Start Date #1. I need to create a new date that is 45 days from the Start Date that populates a new column. Can someone help me create a formula to do so. 😏
-
COUNTIFS with DISTINCT/COLLECT
Hello all, I've been searching for an hour and I can't seem to find the proper solution. Here's an example : I need to count the number of DISTINCT Clients if Rep is John and Renewed and Refused are both unchecked. There are several rows for the same client as there are different type but here, we want to count the number…
-
Form Submission Error Message
Sometimes users of my form get an error message that reads "this form cannot be submitted… contact sheet owner if this keeps happening." Could it be the time it takes to complete the form? If someone is taking too long, does the info time out?
-
Form Validation for Hyperlinks
Add validation for hyperlinks to forms in order to prevent users from submitting form with text in a field asking for hyperlinks only. Users frequently type "none", "NA" or ask questions in the hyperlink field despite clear field labeling, help text and training. Having the ability to validate if the data entered was a…
-
Sort Function
Is there a way to disable the Sort function for a sheet (i.e., an indexed sheet)?
-
Timeline - can I add a marker to a task to identify a unique criteria?
I have level 2 tasks showing nicely in Timeline but I want to show that some of the tasks have something unique about them. I.e. there are 10 tasks in green because they're on track and each shows the label of the task. I'd like to show that 2 of the 10 tasks are for an escalated customer. Any suggestions?
-
Automated Workflow Issue
I have created a request process for our sales team that incorporates automated workflows. As I built it out, I tested each component and every step functioned properly. The team started using it last week, and I have one workflow that will not run automatically. It will work if I use the Run Manually Option or if I…
-
Rich Text Formatting in email notifications (and Update Requests)
Hi, unfortunately I heard from Andree that is still not possible to format text in update requests or email notifications f.e. bold, italic, underlined as well as putting URL-links to certain words or make quotations. I regret this because I find it a very important function and hope you will agree and find a solution.…
-
Enable Cross Sheet References to work with Sheet Summary
I check with Smartsheet to see if this was possible and it is not. I've submitted an enhancement request. Support suggested I post the idea to the Community so folks could "like/vote for" the idea. If by chance someone knows how to do this...reference sheet summary values from another grid, or between sheet summaries on…
-
I'm receiving an unparseable error with this formula? What do I need to adjust here?
=IF({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "3. Moving Along", "Green", "" ({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "2. Needs Monitoring", "Orange", "" ({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "1. Needs…