Hi all -

I would like to calculate if something is due this week based on a target date in another cell.

I have tried this formula:  =IF((TODAY() - [Week Of]1) - 7 > 0, "no", "yes")

This formula pull in a 'yes' for anything that is due in the next 7 days, which is not quite what I'm looking for.

Hello community -

I currently have an approval request enabled that notifies me via email once a day whenever a date in the Due Date column is changed. I also have a dashboard that shows me whenever an approval is needed and would like to eliminate the emails coming in to advise me.

Is there a way

Would love to have S/M/L T-shirt icons to visually look at sizing.  This would be helpful as a project manager and on a scrum

I have created extensive data matrix's to calculate # of Jobs and dollar amount for individuals in our company to track capacity. However, as our sheets get larger, the formulas wont calculate. I receive an error message reading:

"Some cross-sheet formulas cant be updated, because this sheet has

I have a calculation to calculate the number of days between two columns.

=IFERROR(NETWORKDAYS([Date Submitted]41, [Go Live Date]41), " ")  It works great to return a blank if the customer has not gone live.

Then I have formula to calculate the average of the cells.

=AVG([Number of Days to

I'm attempting to set up conditional formatting to highlight cells if there are duplicate dates in the same column. (For a spreadsheet managing event bookings, want to highlight if multiple requests for same day)

I tried an IF/COUNTIF function in a new checkbox column but I keep getting

I was working on a way to track some task hours and minutes... came up with this:

One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore

Hi all,

Been looking but cannot find an answer. I am using SmartSheet with a rental property I have. I want to send guest the information on the property a week before they arrive. I have set up a date field that is a week before check-in. I can see using that as the trigger, but my email appears to

I created a smartsheet using the Gantt chart template. For some reason the Gantt chart lines are slightly larger than the task lines. So when you're looking at a task and look right to see the gantt chart, it does not align with the proper task (Screenshot attached). This seems like Gantt 101 - The

Hey there!

Currently trying to automate a tracking report that my company uses. I want the "District" column to automate based on the property number entered. However, while there is only 7 districts, the list of properties could easily be in the thousands. We can determine the district of a