-
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…
-
Stopwatch Style Time Tracker
I believe the community has been looking for a solution for years. I have successfully created a way to have Stopwatch Style Time Tracking – On any sheet, at the parent or child row, by individual, and allowing manual edits! This is without using Resource Management. I used Bridge to handle the automation and two sheets…
-
Edit Smartsheet or Excel Template (can't locate)
I started using this smart sheet for study planning. I work FT and have a demanding study schedule. I needed to add time to the sheet (15 min. intervals would be preferred) but I can't figure out how to adjust it. I also can't locate this template anymore. Uploading for reference. A tally at the end (sum) for total hours…
-
construction cost estimate for installations
Can someone help me and give me an idea on how to create a cost estimate for installations, with a total for each chapter by groups, subgroups and types of work, but at the bottom of each chapter. https://us.v-cdn.net/6031209/uploads/0OSH46KSC2LH/cost-estimate.xlsx Thanks
-
Freeze columns - do not stay in place in Grid View
When freezing a column, things stay put usually, but the frozen columns retract / collapse upon saving or moving the app / browser from one monitor to the other. When this happens, the user needs to stretch the frozen column to back to its original orientation.