I have a Smartsheet (Smartsheet A) with multiple date columns. These dates have been added using various formulae. I also link some of these dates into a master sheet (Mastersheet A) that consists of a Gantt Chart.
The dependency settings on the Mastersheet A with the Gantt chart is such
I have two rows with multiple date type columns.
I need to added a conditional formatting where, if the date in row is greater than the date in other row, the cell with greater date needs to be highlighted.
Someone Kindly help.
I am new to the aspect of resource allocation.
I need to know apart from people can objects (computers, scientific instruments etc) be allocated as resources, as I need to keep a tab on the overuse of certain equipments at my organisation.
Next, can only people with licensed accounts
I am creating a report to check the incoming date of certain items for multiple projects.
While creating it, only the parent row is getting imported to the report. Is it possible to incorporate the children rows as well ?
The structure of my rows in the original sheets are as follows:
I am trying to build a report on Smartsheet using multiple sheets. Each of this sheet has atleast 30 rows.
Is it possible to select rows while building these reports ?
There is an option to choose columns. Howeever, I do not need all the rows present in the sheet.
Is there any way to do the
I have a master sheet, where I am keeping track of the progress of various tasks. The progress is being monitored using checkboxes.
The structure of the sheet will be clearer through IMAGE A. Each project has it's own smartsheet and I would like to format the master sheet based on targets met
I need to apply conditional formatting to a date type cell. I need to write a formula such that, when a the target number for a certain task has been reached, the deadlines for the next target has to be set.
For Example, if the target for task A has reached today, then the start date for