I'm trying to figure out a formula for "Site Health". Each site has 9 milestones that will have a "Milestone Health" column. Each milestone must be completed a certain number of days before the projec…
Hi, I have the following formula in a column, =COUNTIFS({Sheet Range 1}, [Column Sample]@row, {Sheet Range 2}, "ABC", OR({Sheet Range 3}, >TODAY(), {Sheet Range 4}, >TODAY() I need to do if column A =…
I am trying to use the Modified Date column in formulas. For some reason, it doesn't appear that this was created as a "Date" column type. Because of this, it cannot be used in any formulas that would…
Hello, for some reason I am having a recurring problem. Well, 2 recurring problems in the same vein. I am trying to pull in data from one sheet to another using index/match. I am positive that this fo…
Hi Community, Are you tired of having to manually go into each role and set individual permissions whenever adding a new page to WorkApps? Not anymore! Smartsheet’s new features now allows users to se…
Hello All, I am trying to utilize a formula from a sheet (Parts Requests) to drive productivity and scheduling on another (Scheduling Board). I have created a formula [Report] to determine if the corr…
Hi, Is there a way to organize attachments, so I don't have to scroll through all my attachments? I saw a question like this from 2021 and was wondering if there was a solution. Thanks
I'm trying to figure out an easy/dynamic way to sum a column. Right now, I have Column A in Sheet 1 that is a multi-select. I want to lookup the result of that multi-select in Sheet 2, and total the v…
Hi, I want to automate the status column of the parent row based on the child rows. For example, if all of the child rows are left blank or marked "Not Started," I want the parent row to read, "Not St…
I need to calculate the planned date against the Go-Live date for each column. The dates are above the columns that should be prior to the Go-Live Target which is 10/31/22. I need to make the actual c…