-
TODAY() Automated workflow birthday not calculating correctly
We've automated a work flow for birthday notifications - so we can celebrate folks. The workflow/notification shows an incorrect calculation - age = 20, when it should be 21. Here's the notification: And here's the data we're pulling from, showing the correct age calculation: I'm assuming this may have something to do with…
-
COUNTIF year is current
Can anyone tell me what is wrong with this formula for counting rows containing the current year? =COUNTIF([Date Completed]:[Date Completed], YEAR(@cell) = YEAR(TODAY()))
-
SUMIF using or & and & contains
I am needing to sum the Estimated Budget for everything that has a Status of "Proposal with Client" or "Sales Order with Client for Signature" AND if the Session-Service column contains "Assessment" or "Test".
-
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…