-
Hidden sheets in a Resource View
Hi I have a Resource View and some resources are shown 150%, as they are mentioned in a long-forgotten sheet (displayed here as "Other sheet") that is not maintained anymore, not shared and the owner is unknown. How can I figure out where this particular resource is used please? Thanks Attila
-
"Modified / Modified by" fields
I noticed that when I save a shared sheet, the columns "modified" and "modified by" change to my login and the time stamp when I saved for ALL rown in the sheet. Is it how those column types are supposed to work? In the help contents, I read that those columns change ONLY in the ROW where data has been changed. It doesn't…
-
Formatting for Project Lists - suggestion
I was hoping there was some formatting option so that when I set a status to complete (either green orb, full circle etc.) that there would be a way for that row to automatically be moved to the top of the sheet. That way the "in progress" and "completed" tasks/projects could be better organized. Just an idea. Thanks
-
Report planned work on a weekly basis
Is there a way to know the estimated % of work to be done every week? I didn't find a report about this, but this will be very helpful to track the overall execution of a project. Example: week 1=5%; week 2=18%; week 3=24%; week 4=32%; etc...
-
Card View
Any Card View Users? See Screen Shot How can I get Card View to specify the Column Name on the card? Ex: On the Left Card - "JOB# 10002121" 10002121 is JOB# Column but when I'm looking at Card View it doesnt clarify that. I can work around this by manually adding "JOB#" in the cell before the #s HOWEVER, when it comes to…
-
Sheets with Formulas & Web Forms
Whats the best way to handle a sheet (with formulas) populated by a web form? Right now, each Web Form populates at the end of the sheet, where the formulas stop, how can I eliminate that from happening?
-
Card View Lanes / Drop down
I'm using a sheet populated by a web form and using Card View as "Default" View. Card View is Viewed By "Machine Submitted By" The "Machine Submitted By" is a drop down selection on the Web form Is it possible to have "COMPLETED" as a lane on Card View WITHOUT allowing it to be a selection on the web form dropdown?
-
Sheets populated by Web Forms
I have a sheet that is populated by a web form. * The production floor inputs data into the web form. * The quality lab is "View Only" on the sheet. (on a display screen) Is it possible for the sheet to auto-refresh when new web form results have been added? The goal is - as soon as new info is added from the production…
-
Count Blank Cells
Hi I am using Smartsheet for invoice approvals and would like to summarise how many documents are still awaiting approval. I have tried using a countif formula to count all cells that are blank in a certain column, however I get results that include lines are not used, e.g. there are 10 documents entered on separate lines…
-
Update requests
Hi everyone, I have built a sheet in smartsheet to track supplier performance. When there is an issue with their performance, I am wanting to send the supplier a update request in order for them to provide corrective action for problems and it to be written directly into the sheet. This works great but to provide context…
