-
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},…
-
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