PeterG’s Profile

Community member since May 2018



I have a report that is set to show rows that have a "Date Published" column where the Date is equal to today or is in the past.  For examples sake 12 rows in total. 4 rows have a past date, 4 rows have today's date, and 4 rows have no date or a date in the future.

When viewing the report directly,


Conditional formatting using a date, is not taking into account the local account regional settings/timezone and appears to be using a default time zone.  As conditions like change the color of a cell if the date in that cell = Today, is still highlighting the cell on the next day.

My Time zone is


I have created a set of reports (that selects this project) and an overview/summary sheet that has links into the underlying Project Sheet.  We use these set as a template to save an copy to a new workspace or folder for each project.

I am hoping there is a way to make the project/sheet links stay


Hi, we principally use smartsheets to generate Gantt charts for our various projects. Ideally we would like to set up conditional formatting (for example task-bar color) for all of the children of different parents. 

So for example, let's say "Phase 1" of a project is the parent, we would like an


This is my current formula and it is working fine.

=IF([New/Existing]2 = "New" = AND(Segment2 = "Broker"), 0.4, 0.6)

I want to add that if New/Existing is BLANK - to not return anything.  Not sure how I can modify this.