I am trying to conditionally format dates that are in footers of grouped cells. The purpose is that I want to conditionally format dates in those cells that are 7, 14, and 30 days ago from today's dat…
Hello everyone, Starting with Smartsheet, I don't find any documentation about distributing a new and unique sheet to collaborators. The idea is : * I build a main spreadsheet, and I want multiple col…
I'm trying to set up a Smartsheet to track the weekly work completed for each staff member and for the overall team. We do invoice processing, which has about 20 different invoice types. We currently …
I want the range of days from Monday the 1st to Monday the 21st to read 21 days; yet it reads "22 days" in the duration column. This is because day 1 is the first day, when I need "day 1" to be the fo…
I want to get this template to smartsheet for the community. Its for a family event with multiple data such as room availability, price, tax deduction, package and room assignment with form. Don't kno…
Hi! I am setting up smartsheet for different departments in a company. I have 10 filters in one sheet and need the same filters for a different team on another sheet. Is there a way I can clone the fi…
I am trying to craft a formula that sources a numerical value in a different column and, based on that value, prints a skill level. Here's the formula: =IF([Points]1 <99, IF([Points]1 <199, “Apprentic…
