-
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…
-
Cant Delete Sheet that I created
I try deleting the sheet i created in a workspace it shows that it work but then when I refresh the page or log out then it comes back. I tried moving them in to a folder in the workspace and they are not movable. I tried deleting them in 1 by 1 then I noticed some of them has this locked access and It is telling me to…
-
“File Creation Restriction”
Hello There , before smartsheet switched to the new license type, the users to whom I gave editing permissions could not share the page unless I granted them permission. In addition, users did not have the ability to create pages. This way, as the admin, I was aware of all the pages created in the company and could…