-
Why are Free Users/Unlicensed Users asked to upgrade to Premium?
Free users within our organization have been having some questions when using Smartsheet. They get confused with this since the message displayed is "You have limited access to Smartsheet. Upgrade to use premium features" and they are not sure if they have access or have can even use Smartsheet. Is there a way to remove…
-
Converting from Trial to License user
Best practice in adding new person onto Smartsheets. We have an open license, but the new user is currently using the free trial. How do prevent any loss in data & ensure easy transition?
-
Change Cell Value and Record a Date in Workflow
Hi there, I cannot seem to add both the actions to Change the Cell value and Record a Date. At the end of the workflow, I want to change a cell to read as "Approved" and record today's date in another field. It looks like I can add one of the two actions in my workflow but not both. Any suggestions? Thanks, Glenn
-
Is there a way to create a Smartsheet based multi-tier Ticketing System
Hi Smartsheet Community, I trust you are all well. I am looking for some guidance to whether the below system will be possible to manage in Smartsheet. I am looking to create a multi-tiered Ticketing System consisting of 30+ Local Site systems, each separate to one another and managed by local site admins. Each of these…
-
Available Symbols in the Status Column
Hey All. I hope you can help me out. I know that you cannot add your own symbols in the status column. However, can I combine from other lists? My use case: I am currently using row 2 in the status list below (yellow - green - red - blue), and I would like to add the gray indicator on the last row going to yellow - green -…
-
Multiple IF statements
Hi Team, I tried to follow the solution mentioned "regarding combining multiple IF statements", I get an Unparseable error. My formula: =IF([PM Effectiveness]@row=🤩 Strongly Agree,"5",IF([PM Effectiveness]@row=🙂 Agreed,"4",IF([PM Effectiveness]@row=😐 Neutral,"3",IF([PM Effectiveness]@row=😞 Disagree,"2",IF([PM…
-
Dashboard Display of Current Month's Value
I'm trying to figure out a work-around for an non-existing feature in Smartsheet. My goal is to display the running total (only) of a chart by using a metrics widget. The picture shows what I would like to see. My struggle is to figure out the correct formula I can use inside my data sheet or sheet summary. Here is the…
-
Status/account conversion to keep qs/issues in Smartsheet Communinty?
Simple question.... We recently changed over our e-mail naming convention. As a result, everything I did prior in Smartsheet (my questions, etc), are no longer available. is there a way to either convert my old community account over or add the 2nd e-mail? I reference issues resolved all the time and it is quite painful…
-
Copy 1 row multiple times to a new sheet
I have a design sheet with proofing that contain columns to check sizes needed for that design (s,m,l). I'd like one copy of that row to be copied to the production sheet for each size needed (so 3 times if need all 3 sizes). The new rows in the production sheet need to have only have one size checked (one row with just…
-
copying and pasting from Smartsheet
Why is copying and pasting from Smartsheet such a problem? I have been on SS since Nov 2018 and this is the worst. CTL-C and CTL-V Nothing. Right click Copy and paste (special) no luck. ETC..