Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Has anyone every had a situation where a formula in a cell calculates improperly if it references a cell whose value is also derived based on a formula?
I have a formula set up where it's looking at cells in the current and previous rows to calculate total hours worked in a day. (I borrowed this formula from one of you lovely community members...thank you!) However, the formula only works if I type in the plain text value in the originating cells. When the value of those originating cells comes as the result of a formula, I get an incorrect calcluation.
Is this a known issue or is it more likely user-error? (I'm assuming the latter, at this point, but wanted to verify.) Are there any common mistakes I should be looking for when things like this happen?
I've included a screenshot of the erroneous calculation below. You can see the 3rd and 4th rows are giving strange results in the "Day Calc" field, given the formula, which should look to see if the previous row occurred on the same day and, if so, add today's hours to the total hours accumulated for that day. As I stated above, I found that if I manually change "hours worked" and just type in "0" and "1" for the 3rd and 4th rows, I get the proper "Day Calc" results of "1" and "2" for total hours worked for 2/28.