I am looking to create a formula that will do the following: If all child statuses = Complete, it will say "Complete" If at least one child says in progress or complete, the parent row will say "In Pr…
Hi Community, There have been numerous posts about how to essentially rollup multiple smartsheet projects into a portfolio/dashboard to show overall status information about the portfolio. I get the e…
I've got a column (called "Dates") formatted as dates. I would like the adjacent column to show the day of the week that date falls on. Using the formula =text((Date1), "dddd") brings back an #unparse…
Hi everyone, I really need help of your expertise. I have develop one form and its purpose is to collect Facility Manager (FM) daily inspection on each floor. I have created one column "Created_Date" …
I have a conditional alert set up in my form to send an email every time a row is added. When I use a form to add a row, it sends me a notification on my phone through the app, but it isn't sending me…
Can someone please explain to me the reason for removing the sheet tabs and changing it to what we currently have now? I understand changes that are less user-friendly up front if they provide an over…
Hi all, I have been trying to figure it out alone but I thought I'd engage the community to see if anyone can help! I have a column in my spreadsheet that contains phrases separated by commas - for ex…
I'd like to see a function like "TODAY()", or cell behavior that supports it, that executes only once when an event is triggered so that the date result that never changes. My use case is a Card view …
Building a kanban board with typical IT cycle states: Ready, Dev, Test, Deploy, Done. I'd like to track cycle times and throughput. I've created (locked) columns to capture a status change for each of…
