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, in a form under a sheet I have one field with a multiple choice dropdown, and each of the option is linked with Logic with another field (also a multiple choice dropdown if it matters). If I choose only one of the options in the field 1, the correct new field appears, but in case of multiple choices, I get either only…
I created my Smartsheet account yesterday using my Google email (patrick@diamondsolarllc.com). My company is based in the United States, but my account appears to have been created in the EU region (smartsheet.eu). I don’t mind being on the EU region as long as it does not cause issues, but I am currently experiencing the…
Hi Everyone, I'm Soumitra Dutta – Entrepreneur & Photographer Based in Oxford. I’m new to Smartsheet and want to get started using it effectively. Could you share your tips, recommended tutorials, or best practices for beginners? Any advice on how to set up my first sheet or manage projects would be really helpful. Regards…
