-
Have an IF Statement Change the status of a field when a value in another column is less then 2
Title is worded weird, but here's a better explanation. I am looking for an IF Statement that reads "If Total Emails per app is less than 2, then change status to Additional Research Needed." Here's my attempt at the formula: =IF([Total Emails per Application]:[Total Emails per Application] < 2, "Additional Research…
-
Grouping Rows
Hello, I have created a smartsheet update tracker, in the format shown in the screenshot below. The separate teams provide their updates in the nested row of the spreadsheet. There are also many formulas on the sheet. I would like to sort these rows from time to time so they can display in progress projects at the top,…
-
Data shuttle- keeping formulas from first row when doing a complete write over of all rows
We are trying to automate a price sheet from an outside system using the data shuttle. We pick up the file from OneSrive and map it to the target sheet in Smartsheet, this is where we are stuck. Is there a way to keep the crazy formulas we have created for all the tiers and discounts without having to manually log back…
-
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},…