-
RYG - Checkbox/Age Group
Hello, I am having an issue with figuring out how to create a formula for RYG and checkbox columns. I have previously set this formula to be based on 'open' and 'completed' requests. Since this has changed we now have 'open', 'pending', 'at risk', and 'completed' requests. The formula, in the beginning, was based on 'open'โฆ
-
How to automatically populate a cell with same info from another cell on the same row
Hello, First time SmartSheet Community Member! I have a sheet with specific rooms locations in separate columns. What I am trying to do is automatically populate the Room column with anything thatโs populated in any of the Building Room columns to the right on that same row. I thought a VLOOKUP was the best to achieveโฆ
-
2-dimensional filter
I have hit a wall on ideas so thought I would reach out to the Smartsheet Community to see if anyone had any ideas, workarounds, or suggestions of how to accomplish a "2-dimensional" filter since there doesn't appear to be the capability (at least I'm not finding a way) to combine the "AND" and "OR" criteria to a filter.โฆ
-
How to decrease decimal places in a percentage?
Hi, How do I decrease the decimal places in the String Column to just read 230%๐บ? My work is below. Thank You
-
Nested SUMIFS each with multiple criteria
Hello, Diving right in to the problem at hand. I have one sheet that handles reagent requests from multiple departments and another sheet that contains all of the stock solutions these reagent requests are made from. I want successfully created a formula that works for 1 sumifs scenario. =[Request Vol (ml)]@row -โฆ
-
Two Separate Contact Columns - One Notification if Same Contact in Both
I have two separate contact columns: each have different notification settings. Is there a way to not send two different notifications if the contacts are the same in both columns? E.g. Manager column + Requester column If the Requester is the same as the Manager - only send one notification. Thank you!
-
Return Adjacent Column Value of a Filtered Item
Hello experts, I am trying to figure out how to display the Status of the Primary Column after the largest Data Point has been determined. The formula I am using under "Largest Data Point" is: =MAX(COLLECT([Data Point]2:[Data Point]7, [Primary Column]2:[Primary Column]7, [Primary Column]@row)) So this tells me the largestโฆ
-
How to count checkboxes-checked, between Nov 1st, 2020 and December 1st, 2020
I am looking for help creating a formula that works with the above question. I will replicate it for each month through one fiscal year timeline. Currently I have this formula which results in UNPARSEABLE. =COUNTIF({Data Range 3X}, true), COUNTIFS({Tuning Release Date Range}, >= A11, {Tuning Release Date Range}, <= A12) Iโฆ
-
IF statement to Output Column Contact List Name
Hello! I feel like this is a fairly easy formula, but having issues populating the ACTUAL contact name vs. the TEXT value using an IF statement. Goal: In this example, when I change the status to phase 1, I would like the Current Assignee cell to populate the contact name. However it is populating the value and not theโฆ
-
Showing a minimum amount if 2 things arent met help
Im trying to get a daily minimum field where if the sum of certain cells dont reach a specified amount then its that amount, but if it does it subtracts it until it gets to 0, right now it's giving me -numbers. also i only want to do this on parent/child rows that have a date field populated already. i then want toโฆ