Sign in to join the conversation:
How do I use a formula in my parent row to update based on the children's status? I want the parent row to to "Active" if any of the children are "Active", "Complete" if all of the children are "Complete, otherwise, "Inactive.
I would use an IF formula. Try this:
=IF(countif(children(),"Active")>0,"Active",IF(countif(children(),"Complete")=count(children()),"Complete","Inactive"))
How could I adjust this formula to say in addition to what's noted, if any of the children are "Canceled" the parent should also be "Canceled"?
Hi, I have five Smartsheet accounts—four with editor access and one admin account. Recently, I’ve been unable to log in to one specific editor account. It shows the message “Too many failed attempts. Try again after one hour or reset your password.” However, I attempted to log in only twice, and the error appeared on the…
I submitted a ticket, but thought I would ask here. I am having an issue with sheets that I own (our org is on a Business plan). For the last two years, we have been using the sheets without an issue - our admin and many Editors (all shown as Guest since they are outside of our organization) were able to edit the sheets…
I've just downlaoded the trial version, and created a sheet. I then downloaded the app and nothing has synced. Anyone had this issue before? Is it a trial issue, or does Smartsheet typically show issues with syncing between web and desktop app?
