-
Formula for totalling specific options
hello! I have a sheet for a menu of options. We are building kits of different swag items and the sheet has 5 different options with different price breaks. I'd like a sales rep to be able to go in and select different options then see a kit price. I was thinking I could add a check box column then pull a report on that…
-
How to access columns after duplicating a form that didn't include them
My worksheet has 10 columns. My form uses 8. I duplicated the form and I have ready access to the 8 columns in the form but I need all 10 now. I don't know how to pull the additional 2 from the sheet. Any advice?
-
Contact List using DataMesh & Concatenate
Hi, I have added 2 columns to a data sheet, one for Analyst Name and one for the Analyst Manager. I have brought in the email addresses of both of these by DataMesh. I want to be able to apply a current user filter to a certain column which would enable the Analyst and their Manager to only see the rows that are applicable…
-
PLEASE HELP WITH TURN AROUND TIME DATE FUNCTION, THANK YOU IN ADVANCE
I am nowhere near a Smartsheet Whiz. We have a column on our main sheet titled Create Date which we input. This is the date a work order was created. I am wanting to have another column titled TAT (turn around time) which will look at the Create Date entered and reflect how many days the ticket is open and continue to tick…
-
Forms do not redirect, shows confirmation message instead
One of my clients have +50 forms. After conditional logic update for forms, several of them stopped redirecting and started showing "confirmation message" instead. Forms are working since ~2017 unchanged and are used in plain mode. No iframes. We have tried duplicating forms, creating new forms - all of them DO NOT…
-
Adding people to Groups
Does anyone know why I am getting this message "Cannot add this user to this group"? I created the group, however it is not letting me add everyone I need to.
-
Inconsistency in how contacts are displayed across sheets
Hi, I have noticed inconsistency in how same contact is displayed differently across sheets. In one sheet it is displayed as name whereas in other sheet its displayed as email id. I understand that in one sheet where its displayed as name, its picking up the name from user name in my smartsheet account. But in other sheet…
-
Trouble with Formula for RYG/Health/Status Columns
Hi There, I'm brand new to Smart Sheet and still learning the abundance of inner workings - hoping to find some help with what is probably an easy formula but I can't seem to get it right! I'm trying to change the color of the RYG ball under my 'Health' column based on the 'Status' column. For instance: Red = Canceled/Not…
-
Splitting form data from multi-select field into multiple columns on sheet
I am trying to use SmartSheet to send out a form to vendors that allows them to select choices in a Multi-Select field. I then need to have the choices the vendors selected in the multi-select field split out into a binary type of indicator on multiple columns in the SmartSheet in order to use the data in a meaningful way.…
-
Copy an Attachment between sheets
I am looking to copy an attachment only between 2 sheets. I can't seem to figure out how to do this! I have even looked at Zapier as an option, but not that familiar with it yet, so not sure how to make it work. Any suggestions?