-
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..
-
Saving a certain view of a sheet and embedding the view
Hello, Is it possible to create a certain view in Smartsheet and save that particular view? Also, would it be possible to embed that view in a dashboard? Thanks Nish
-
Card view only on current/future months
Is there a way to have past months automatically collapse in a dashboard using the card view? I don't want people to have to scroll to get the current month. I tried a filter, which worked on the sheet, but not in card view.
