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


Hi everyone,


I'm pretty new to smartsheet so I may be asking your help for something that is quite easy to do :)


I have an excel formula that I need to migrate to smartsheet to help me transform seconds in HH:MM:SS


The excel formula is =TEXT(IF(I4="";50;I4)/(24*60*60);"hh:mm:ss") & ":00"





I am hoping someone has an idea for a solution to my problem. I have an inventory that keeps track of giveaways. I created a second sheet with a form to fill out how many of each giveaway I pack for each event. I count the giveaways that come back after the event, and I need a way for this