-
New format wastes both time and space
I am very frustrated with the new format. Previously, every single sheet I had open was accessible with a single click, plus I was able to use the entire width of the screen for each sheet. Now, in order to us the entire width of the screen for each sheet, it requires triple the amount of clicks to change sheets: One to…
-
Reminder to complete form to outside email accounts
I have 3 forms, that I need to be sent out as a reminder on a certain date. I have a 4th form I used to collect email addresses that I would send the weekly form to those addresses. I want to keep reminding them to complete the form if they have not by a certain date. So I was thinking I could make a email list (personal)…
-
How do i add more than one duration to a gantt chart?
I have a project that has hundreds of tasks. Each task has a fabrication duration and a delivery/logistics duration. How can i add an extra column and add the extra duration per task to show in the gantt chart in maybe a different shade or different color? The other solution, would be to add a line below each task just for…
-
Contact Columns marked Multiple Don't Populate Legacy Reports
I have 140 or so projects I manage reporting on and was excited to see that we could now do multiple contacts in our Assigned To column. However, when adding new projects with this feature enabled I noticed that Reports count those columns as different than other Assigned To columns without this feature enabled even though…
-
NETDAYS failure
I cannot figure out why this formula doesn't work for me. I've tried a date instead of TODAY(), same results. Any help appreciated. Both columns are formatted for dates.
-
Dashboard Color
Any plans in the future for letting us update the dashboard background color to any color we'd like? I'd love to be able to use black for dashboard backgrounds, as well as the backgrounds of the widgets, so that when on TV sets around the office, graphs are floating in black instead of a white background.
-
Summarize data for graphing
Hi, I have a large data table used an experiment tracker, and I'd like to summarize columns to graph on the dashboard. The first column is a drop down list called vessel type, which has 12 different vessels. The second column is a drop down of pass, fail, and pending. I know I can use the COUNTIF to tally the number of…
-
Scanning a Barcode
Does anyone currently know if smartsheet is capable of capturing data from a bar code?
-
Incomplete work left to go
Is there a way to calculate work days "left to go" where the task is not marked complete while ignoring simultaneous tasks (tasks that have the same predecessor)? It seems like networkdays should get part of the way there but it seems like i need an "if" statement to look at complete. Is there another way to get there that…
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…