-
Collecting time range in form
I'm creating a form to collect the days and times that employees will be out of the office so that I can get the info onto a dashboard for the team to refer back to. Since Smartsheet doesn't have time fields for forms the best workaround I could find was using dropdown fields with half hour time segments and have one field…
-
Workspace Panel Auto-Opening
I know this topic has been addressed previously and was resolved but is now happening again. Is there a way to disable or remove the workspace panel from auto-opening each time you open a sheet? It's extremely frustrating!
-
Should Smartsheet Reconsider Pricing Policy for Live Support?
Would anyone else like to see Smartsheet reconsider their pricing for users that need live support? I manage creative services projects for a large healthcare organization and am one of only a couple users that would ever need support. As a not for profit, it would be a waste of money for our organization to buy support…
-
Cascading timelines by linking timelines
I have three grid sheets, named Sheet 1, Sheet 2 and Sheet 3. The timeline of Sheet 2 is dependent on Sheet 1 timeline and the timeline of Sheet 3 is dependent on Sheet 2. I want a function wherein if the end date of any one task of Sheet 1 gets changed then it automatically changes the start date of the task of Sheet 2 or…
-
Workaround to sort Report rows manually?
Anyone have a workaround solution to sort Report rows manually? For example, we need to put priority items at the top - but that priority is manually adjusted (not logical). Using a 'Priority' column to sort by doesn't work, because they want to move around and see how it's adjusted without having to save and refresh the…
-
Canada in Form Phone Validation
Greetings, Field Settings - Validation - Phone. If you select Canada and save it. The form will display the United States. I went back into settings to double-check the settings were still set to Canada, while the manage form view displayed the United States. Ultimately, my goal is to automate a dropdown with logic that…
-
How to get the same name from two different sheets to populate a third cell based off their response
I have a sheet (Sheet 1) that is being populated with a person's information after they fill out a form. Smartsheet then sends out an email to that person through a workflow to follow-up with them. The email contains a smartsheet form that allows the person to put their name and follow-up answer. This is populating Sheet…
-
Is there a class/how to guide someone would suggest when using the policy template?
I am new to Smartsheet, but catch on pretty quickly. I did not find anything in the university.
-
How can I add days to a date field within a logic formula to output a true/false value for a chkbox?
My objective is to create a new column where a box is checked once the row meets desired criteria. The checkbox will help me filter-out rows that will be synced via a Salesforce Connector workflow. The logic criteria is as follows: "Overall Status" = Blue (complete)….and…. "Working Launch" Date + 7 Days </= Today's date…
-
Why i am getting one combined email when adding multiple entries in a form
Hi Friends Hope you are doing good and staying safe! I am using Automation>Trigger>Alert someone feature to get email notification when user submits the form. I want to get individual email for each entry, however if user submits the form multiple times with different data, i am getting one combined email instead of…