-
Date Default to 30 Days
Hi! I am trying to put together a formula that says: " If the Renewal Alert Date is blank, change column to 30 days"
-
Conditional Formatting
Hi I have a sheet where the user would like to have rows highlighted in Red, Amber, Green based on when the last review date was completed: Review in the last 10 months - Green Review in last 11 months - Amber Review in last 12 months (or more) - Red I'm unsure the best way of doing this - do I need a formula in a helper…
-
Dropdown box Data in formula
Hello all, and thank you in advance for any help that you can provide. I am using a dropdown box, single selection, to select a date that determines data pulled from a table. I have 10 data values for each date in the table. I am attempting to use VLOOKUP to collect the data with the date from the dropdown box as the…
-
SUMIF multi-condition syntax
a Coworker and I have been banging our heads on this one for a couple weeks now for a project under development. We're trying to SUM hours {TotalTime} within a date range that meets a label criteria (@cell, Month16). It actually works until I add the AND condition. Below is my #INCORRECT AURGUMENT SET =SUMIF({Activity},…
-
Lookup Values in another sheet and bring back data based on city name
Hi, I have a master sheet and have created a new spreadsheet for a project. I am wanting to see if it is possible to look at the city name from my my 1st sheet (ORIGINAL SHIP TO LOCATION) and bring data back from the master location sheet in a column titled STREET? 1st sheet name = MASTER Locations 2nd sheet name = IRE…
-
Formula for if cell contains one of many things, return that thing
I'm looking to create a formula for if a cell contains one of a list of things, it will return that thing. In excel, I would use the method found in this article (https://exceljet.net/formula/if-cell-contains-one-of-many-things) but have not been able to recreate in Smartsheet.
-
Formula for RYG status based on Drop down column marked: Complete, In Progress & Not Started
Hi there! I am looking for help creating an IF formula to produce the RYG based on another column that has a dropdown (Complete, In Progress & Not Started). This is what I had: =IF(Status@row = "Completed", "Green", IF(AND(Status@row = "In Progress", "Yellow", IF(AND(Status@row = "Not Started"), "Red"))))
-
How to autofill a cell with an incrementing number for each time a value appears in another column
Column formula request: I'm trying to assign a numeric value to a cell and increment up for each instance a code shows up in another column. For example, if a column has NH002 in it 4 times, the first time, the cell should have a value of 1, and repeat until it gets to 4. Once NH003 starts, it would start over at 1 and…
-
Sumif Formula
I’m trying to total the number Enrolled Students if they meet the criteria of being in the Eastern New York Region. I’ve being going in circles with the sumif formula and keep getting an error message. I really struggle with formulas -- even ones that should be simple. Can someone help me write it? Thank you in advance!
-
Contains Formula
Hello, I am trying to make a CountIfs formula that counts across a different spreadsheet, on if the comments cell contains the words "Moved", "Delayed", "Rescheduled", "Canceled", then output the number of these delayed cells. Having some trouble getting this to work as I think an OR statement is nested somewhere in here.…