-
Countif Issues
Hello, I'm trying to create a summary report based on the number of registration per week. Can you help me with the formula as countif function does not work. Thank you!
-
Formula
Hi I'm trying to return a boolean based on another column - If the column is blank, or the date is within the last 7 days, I need a 0 to return, if it's not blank and the date is greater than 7 days from today, I need it to return a 1. I'm currently using this formula: =IF(OR([Current & Pipeline Last Updated]@row =…
-
RYG formula
Can anyone help with a formula that uses an RYG (red, yellow, green) to set the status of a task based on its percent complete: If a task is less than 50% complete, turn the RYG light "Red" If a task is between 50-99% complete, turn the RYG light "Yellow" If a task is 100% complete, turn the RYG light "Green" Thanks
-
Locking Values in Row
I have a column on Sheet 1 that has a formula that references a value on Sheet 2. If the value on Sheet 2 changes, obviously the cell in Sheet 1 updates automatically. I have another cell in Sheet 1 that is a dropdown. One value in the dropdown is "Completed". The values in Sheet 2 may change once a year, as we adjust…
-
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…