Is there any construction companies out there that use Smartsheet other than for job tracking and HR? Maybe budgets and scheduling manpower? I need some ideas on how to set up those activities on smar…
Hi All I'm building a budget sheet and am trying to figure out how to change the color of the font if it adds up to be over budget. For Example: =IF([Column]1 > [Column]2, "Red") But by doing that, it…
I use the cell linking extensively, however it would be so very helpful if cells could be updated from either sheet... For example, I have a master project sheet that consolidates lines from mulitple …
Hi, I would like to be able to return the Row ID of a given column - to use in the following formula: =ROWID(ANCESTORS([Task Name]1)) Which should return the row ID of the first ancestor (Parent) or t…
Hi all, Is there a way to add a column which displays the ParentID to a Smartsheet? If I had this, I could produce the report I am trying to build I expect. Hep appreciated! Thanks, James
Hi, Recently a number of links between two sheets that I use have been broken. It is not consistent (not all of the links were broken). Are there guidelines on why links could have gotten broken? Than…
I am trying to get a summary of duration for a particular resource within a particular month in smartsheet. This is unfortunately so that I can then input the hours into a custom ERP that lacks any in…
