-
IF(AND with multiple sheets.
I am trying to have a check box mark if the following are true If the individual a review was completed about (sheet two) matches the individual name at the row The type of review completed (sheet two) equals the "Specific Review" Example of what I had that is erroring. =IF(AND({Data Collection All Reviews Range 1} =…
-
COUNTIFS Issues
I am having problems getting COUNTIFS to work. I have two different formulas I am trying to set-up in different columns. I would also like cells that return as zero to change to blank. Does anyone know how I can fix my formulas and also set them up for "0" to change to blank? 1.) I need a formula that counts the amount of…
-
=INDEX(COLLECT Issues
Hi Smartsheet Community! I’m having problems in getting the below formula to work. Any help would be much appreciated. =INDEX(COLLECT({Risk Matrix 2 Range 4}, {Risk Matrix 2 Range 5}, [Current consequence]@row, {Risk Matrix 2 Range 6}, [Current likelihood]@row), 1) I’m trying to grab the value in the third column when the…
-
Tasks due in the next 5 days
Hi Smarties, Need help here. I want to know how many tasks are there due'd in the next 5days. I thought this was easy but somehow not getting the result! Let's say today is 18th Aug, from the below, the result should be 1 (19th Aug). However, my formula returns 2 in the sheet summary. This is the formula I used to find out…
-
Need to Count Distinct Based on Multiple Criteria
Hi there! I have a database (Sheet 1) where I log all my company's gifting to social media influencers and the subsequent exposure on Social Media in one sheet. I organize them by the Name of Influencer, the month we gifted, the month they posted (if they did, otherwise its blank), among others. In a different sheet (Sheet…
-
Pulling Names into Another Sheet
Hello, I am attempting to pull "In Progress" Partners into another sheet as an entire column, the purpose of this would be to create a datasheet on "In Progress Partners" who are associated to different stages of the Project. In the picture below I am pulling Partners with the right criteria, but I am hoping to create his…
-
SUMIFS Month and Year
Hi, I have this formula to sum transactions that match the month - it works well. =SUMIF({Bank Date}, MONTH(@cell) = 7, {Bank Received Amount}) - SUMIF({Bank Date}, MONTH(@cell) = 7, {Bank Expended Amount}) I want to add a second criterion to match the year as well, I get #INVLAID OPERATIONS. =SUMIFS({Bank Date},…
-
RAG Formula & Date Formula
Hi I have 3 questions that I just cannot figure out! 1). I want to auto set my RAG based on a score - I've checked the other community questions and have a formula (shown below) based on previous answers but I'm getting a #UNPARESABLE error 2). I want to set a boolean based on whether a date is more than today +7 days in…
-
HLookup work around
I'm brand new to Smartsheet and trying to figure out the best (most elegant) solution to get the result illustrated in the screenshot below. Any help/suggestions would be most appreciated. TIA
-
Use DISTINCT with COUNTIFS
Hey Guys! I am so excited to see that Smartsheet has finally introduced a formula that will compute DISTINCT(Unique) values!! So, I am trying ot develop a formula to calculate DISTINCT count using one column but with a few condition(s) i.e. IFS i.e. [Range1,Criteria1, Range2,Criteria2] Refer below a sample of that…