Hello, I am trying to set conditional formatting to highlight due date cells when it is within 3 working days, however the sheet counts Saturday and Sunday as days. Is there anyway of setting the sheet so saturday & sunday do not count as days?
Hello community, I apologize if this comes across as trivial, but I am wondering what the optimal solution is to show charts (pie, mostly) showing what percentage of cells in a sheet have the symbol Red Dot / Green Dot / etc. Can I access those symbols directly? Or can I do some sort of IF statement which assigns a value…
Is there a way to share one sheet to two workspaces? Would you have to copy the sheet and have all fields linked so that the changes you make to one sheet would show up in the other sheet? Thanks!
Hi, how can I delete all comments for all rows in one go for a sheet? Thanks
Is there a reason why my subtasks keep getting mixed up in different entries? For Example, Job "A" has 10 subtasks, Job "B" has 5 subtasks. Once saved, Job "A" showing all 15 subtasks???
Hi, We accidentally deleted the sheets in our accounts, because we want to change the plan. Case number 02911830 Can you please help us how to get back the sheets that were deleted from "deleted items"? Thank you, Divya
We have lots of alerts/actions/notification rules setup across lots of sheets. When I delete a user due to employee termination, then I get this message: "Invalid recipients in Alerts and Actions rule" I don't want to have to dig through dozens of sheets to remove the people, how can I do this on a mass scale?
We use a unique number sequence by combining two integers for each row sent to Smartsheet. I worked with Zapier to verify that the integers are sent to Smartsheet as a string, not a number. What I am seeing is if the string is not long enough, Smartsheet converts the information to a number and our formulas do not…
Hi, Is there a way to sort a sheet where the formulas do not change. I have a few formulas at the top of a sheet and whenever someone sorts through the sheet, my formulas change based on where it was moved to. My formula is a COUNTIFS and I want it to count what I am asking regardless of where in the sheet the row where…