We do a lot of service jobs that we use smartsheet for. When its done they mark status as "Done". I know I can find the total amount of done rows by: =COUNTIF(Status:Status; "Done"). But how do I make…
Hello! I am wondering if you can set scheduling on Smartsheet, and if you can, a program on Smartsheet for scheduling based on employee skill sets on Smartsheet. If there is, how would I go about doin…
Does anyone know a way to revert the view so that there is the small pop-up window for attachments which is just like the comments vs. the view with the right reading pane. I do not like the reading p…
I am getting the "this action could not be completed because your sheet as exceeded the maximum recommended size" error on a sheet that I don't think is at the maximum. I have 3,256 rows and 8 columns…
Community, I want a date to be filled in when I select a checkbox. I came up with the following formula but supplies the current date. I want the date cell to show the date that the checkbox was check…
Hi, Getting this error in only on one sheet. There are about 20 sheets, but only one throwing the error. Originally, the formula was more complicated, so I tried troubleshooting to see which function …
In MS Project I could have three lines in my timeline e.g. * Month (July 19) * Calendarweek (W34) * Calendardate of the Monday (04) as in July 4 Is there no way to do personalize this in smartsheet? T…
Hi, I'm trying to limit the columns shown in Gantt View. We have some cells that are reporting info from a link. Sometimes these values are very lengthy. 300 words? The problems is this makes each row…
Hello, I have built a sheet summary with formulas that look something like this, =COUNTIF(Provider1:Provider154, "Syringa"). The problem that keeps happening is that the cells I referenced to count, a…
