How do I get my columns to update steps?
The issue I'm having is that my “Last steps # of Changes” column isn't updating after the "Date of Last Steps" column is updated. Someone please help, I've been trying to figure this out for months.
Answers
-
Can you provide more details? How is [Date of Last Step] being populated, and how is [Last steps # of Changes] supposed to update?
-
The A.) "Last Steps # of Changes" column used to update by itself once the B.) "Date of Last Steps" column was updated by someone on the team. So A is reliant on B in order to essentially show how many times the date was updated so we can track project completion timelines. Let me know if that's helpful!
-
Ok. I got that, but HOW was it being updated? Were you using a formula, an automation, manual entry, something else?
-
We were only manually entering into B. A most likely used some kind of formula or automation to update. This issue was passed down to me without providing all the details, so I'm using context clues to figure stuff out hence the lack of details.
-
What would be the logic that determines what the column is supposed to update to? Are there any automations built into the sheet? Have you checked the Activity Log to see if there are any indications (clear filters to go all the way back to sheet creation if needed)?
-
Thanks for your comments, Paul! Would you be willing to set up a Zoom call to help me sort it out? I'm still having the same issue and waiting to hear back from support who couldn't seem to pinpoint how to resolve it.
-
If you click on the first link in my signature, you should be able to fill out a form to contact us.
-
Apologies for the delay! I was able to fill out a link for the "10x Time Savers" if that's the one you're referring to. I've gone through a lot of back and forth but sadly haven't been able to get the feature I'm looking for. It seems creating a function might be the best day to do it. But I hope we (or someone from your team) can connect with me soon.
