Welcome!

Rows have (mysteriously) deleted

Michal Holtz

Hi,

few rows were disappeared from a sheet. When I look in the activity log, I see that this was done on the rows:

Row: "Druva" Duration: =CALCDURATION([Original Start Date]68, [Due Date]68) = 0 to: =CALCDURATION(#REF, #REF) = 0

Any idea what happened?

Find more posts tagged with

Comments

Mike Wilday

It looks like your formula changed. Perhaps your rows were deleted or cut. #Ref is an error message that communicates that the references that were there no longer exist. Can you confirm that row 68 still exists?

Michal Holtz

No, this line was deleted.

But now I understand what does it mean.

Something has been done but the activity doesn't say exactly what.

Thanks

Paul Newcome

Were the columns deleted and then re-added with the same name? That would cause the same error as well.

Sign in to join the conversation!

Quick Links

Trending discussions

Why isn't my sheet pulling into a report?
I created a new sheet for my team by replicating an older sheet and now my tasks aren't pulling into my task report or any of my teammates. I confirmed the sheet was selected in my report but it still isn't pulling in. I've never had an issue with this before so would love some advice on troubleshooting.
construction cost estimate for installations
Can someone help me and give me an idea on how to create a cost estimate for installations, with a total for each chapter by groups, subgroups and types of work, but at the bottom of each chapter. https://us.v-cdn.net/6031209/uploads/0OSH46KSC2LH/cost-estimate.xlsx Thanks
Editor-Cannot Share Rights
Hi Everyone, I created some forms for our powdercoat test logs. The forms are working great for the employees to input the data. The problem I am having is with giving the supervisors and managers access to the sheet. I gave them Editor Cannot Share permissions to see and edit the sheet. But they are saying that Smartsheet…