-
Option to include Children rows in Filtered results
I maintain master lists of initiatives in one sheet for each program I'm tracking but not managing. When conducting reviews, I filter the list of initiatives based the stakeholders I am meeting with. Most often, the Children of row item that matches the filter criteria are needed for discussion during my reviews. I…
-
Countifs in date range and value range.
I am stuck on this formula, it doesn't become unparseable but it doesn't result in an accurate count. My goal with this is to is to keep an annual tally of a specific age range of patient the formula is as follows: =COUNTIFS({Trauma Chart Audit Age}, <15) + COUNTIFS({Trauma Chart Audit Age}, NOT(ISNUMBER(@cell)), {Trauma…
-
florin schmanek
The original owner shown on our Smartsheet permission rights as owner has since left the organization how can I change my permission rights from Adm to owner?
-
Formula for Milestone Health
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 project end date (October 31-22). I don't know how to create a formula to make the milestone health Green, Yellow and Red. At the…
-
How to use OR for COUNTIFS, referencing 2 columns in another sheet
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 = 1. column B = 2, (next should be OR) or column C = 3 or column D = 4 Please help out!
-
Extract Date from Modified Date
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 allow a date. Is this assessment correct? Also, is there a way of pulling the date out? I've pulled out the Month, Day, and…
-
INDEX MATCH is not pulling correct data even when formula is correct
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 formula is correct because I use it about 100 times throughout all of my sheets. In this particular sheet, this formula is not…
-
Big Time Saver: You Can Now Add Page Permissions in WorkApps
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 set permissions whenever they add a new page in WorkApps, reducing the number of clicks it takes to change role settings as…
-
Cross Sheet Formula(s) w/ Yes, No, and Hold Decisions (IF & AND)
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 corresponding materials order has been received, on order, shipped, etc. which corresponds to a Yes, Hold, or No decision icon.…
-
Organizing attachments
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