Hi all,
Is there a reasonable way to know if I'm getting close to the cross sheet link limits?
Thanks,
Darrell
Hello,
There currently isn't a built in feature you could use to identify the number of cross-sheet cell references, but this would be a great opportunity to submit a Product Enhancement Request (you’ll find a link to this here in Community under Quick links on the right).
=IF([Due Date]@row > TODAY(), IF(AND(Status@row = "In Progress", Status@row = "New", Status@row = "Not Started"), "Yes", "No"))) The goal is to flag items for escalation based on the due date and status. If the due date is in the past and the status of the risk or decision is in progress, not started, or new then I need to…
Hi - we are performing an audit and we need to take the data, and have the consumer validate that its accurate, and if not, identify the change required. What's the best way to tackle that? I was thinking a form but there could be lines and lines of data to validate; is it as simple as having them review the sheet for…
Ultimately, I need a good way to track if we are completing tasks on time based on our original estimates because we have users that estimate a task will take 5 days and when it takes 15 they just change the dates, and the project status still looks green, when is reality it is behind. I would like to have target start/end…
