-
Lock single cell
It would be very useful to lock a single cell. I see it's been asked many times on the community but I did not find anyone submitted it as an idea
-
Smartsheet Support Issue
I'm currently having issues with my Smartsheet environment. I pay $72/mo for 3 licenses when I only need one, yet when I have issues my support ticket has remained open for 2 weeks without being assigned. I've looked for help within the community, however when I posted my question a simple response by a random user marked…
-
Metrics Widget Formatting Issue
Hello, I have created several sheets and reports to be able to live track my progress in a teacher training program. I used a Metric widget to pull the remaining hours from my sheet into a dashboard which works beautifully in the desktop version, but when I look at the mobile version, the formatting is all messed up. I've…
-
Contact List Type Time Outs
Has anyone been experiencing any difficulty when you add a Contact Column type and try to add names? Seems to be happening on all my Smartsheets instances. Two separate accounts on two separate machines, only on the contact column when I try searching for names. Basically when I go to add a name for the drop down this is a…
-
Viewing Data After Automation
I have a form attached to an "intake" sheet. That sheet receives the data, then pushes it to one of two other sheets depending on the response in certain fields. The intake sheet, according to this workflow, should always be empty. We had a row push to the appropriate sheet but some fields were missing. I'm trying to see…
-
Formula to count # of tasks overdue based on date
What is a formula to count the # of tasks that are overdue, based on a date?
-
Replace column of data from Excel snapshot
I had data deleted from a column in a tracking sheet. (2K+ rows) I pulled a snapshot from the activity log and I want to pull back the data from just the one column. I was told the right process was under File>Import>Update Rows, but I don't have that option under import. Is there another way to do this?
-
Table View - No Reminder Option
Smartsheet Grid has the reminder option. Smartsheet Table (New) it does not has it or at least not in the same area as Grid, does anyone know why, or how do I get it while in the Table view?
-
Average duration formula
I'm trying to get a formula for a sheet summary value to calculate average duration of rows where Risk Type = "EDAM Risk" and Status = "Resolved - Mitigated" or "Resolved - Decision." Assuming: Duration is in a column named Duration Risk Type is in a column named Type Status is in a column named Status I've been using the…
-
Need advice on sheet layout
I'm looking for some advice or suggestions on sheet layout. Attached is an apartment "booking" sheet, all currently manually entered from another source form. As you can see it's not well laid out, it doesn't easily show periods when a given room might (or might not) be available. In general, just very janky. But, I can't…