Is there a way that would enable me to reference an infinite range starting from, for example, the 5th row down. Currently, my solution is to use indents and use the CHILDREN([Columnx]x) function. HOW…
Hi Im new to smart sheets - so thx for helping newbie Im trying to drive a planned finish date i use the workdays formula - grab the planned start date, then try to add the number of days from a calcu…
Hi, I was wondering if there is a way to embed/link an image to present itself in the cell if that cell was to presented as 'true'. I want to be able to tick a checkbox and for the 'true' value to pre…
Hi, I am looking to pull rolling data onto a dashboard. i have the cross sheet formula working well however i am looking for some help with an addition to this. I would like to add to the formula to l…
I'm looking to find the change in process duration before and after a process improvement project. I'm asking for the length of 1 unit of work both before and after a process improvement effort (in Hr…
Hello I have a sheet that tracks number of days we are over or under staffed with a -2, -1, 0, 1, 2 I would like to add a criterion that it only counts the days that are after today. Here is the formu…
Under project settings I want to make Saturday and Sunday as working days so "Hard" products would follow a timeline that includes weekends. A task starting on October 1st with a duration of 31 days …
I am using this formula and everything looks okay but the text that shows up for "Delivered Early" is showing up in the field as 0Delivered Early. I don't know why. =IF([Days Late / Early]3 > 0, "Deli…
HI all! I have a several sheets with formulas. Normal, as almost every user of Smartsheet. I wonder if anyone else has the same issues with formulas as me. Sometimes, for long time my formulas are cop…
