-
Auto inputting a date based on a status change
Hi, I want to set today's date in a date column when the status, in a status column on that row, is set to something other than 'open'. I don't want the date to change once it is set so the TODAY() function does not work for me. Is there a function to do that? Regards Mike
-
IF formula with date range that defines a set time period
Statement to solve for - If FINISH date is between x and y dates, the it = 30-60 (time period in a drop down) Formula created, but not working =IF(Finish)42 >=DATE(2020, 12, 21) OR <=DATE(2020, 12, 25), "30-60") Can anyone help solve for this so that I can automated setting a time period based on the task date?
-
Return a number count based on criteria within two separate columns
I'm seeking a formula that will return a value if a certain criteria is met in one column and another criteria in another column. For example, I'm trying to count how many items there are that have "Medium (within next FY to 3 yrs)" with a status of "Green". I'm trying to report this in Sheet Summary. Thank you!
-
IF statement that sets a drop down symbol
Looking to utilize Harvey balls so when a % Complete is within a range (see below) it defines the proper Harvey ball. I am able to accomplish the formula using 2 variables but unclear how to set for a range? FORMULA =IF([% Complete]1 >= 0.9, "Green", IF([% Complete]1 <= 0.8, "Red") Example Ranges for Harvey Ball. G 90-100…
-
Can you use an If...Then Formula to populate multiple columns?
Hi! I am looking to create a formula that will auto populate three columns depending on what region is chosen. For Example: If the region chosen is the Northeast then I want Person 1, 2 & 3 to auto populate. If the region chosen is the Mid-Atlantic then I want Person 1, 4 & 5 to populate...and so on. Is this possible? I…
-
SumIf if cell is a number
Hello! I am trying to create a formula that calculates the sum of the following columns: Column1,Column2, and Column3. These single select dropdown columns are restricted to the options N\A & numbers 0-10. I need to create a formula that omits the option N\A and sums the other columns. Thanks!
-
Count criteria in multi-select dropdown
Is there an edit (or alternate formula) to the 'COUNTIFS' formula I'm using to count all instances of a particular criteria whether or not its included in a dropdown list on its own or listed among other criteria? As an example, the formula currently show is only counting instances of "SRC" when it's the only criteria in…
-
Imported Formulas from Excel
Happy Wednesday! I have been going in circles trying to figure out where this formula is going unparseable. I researched it against other similar (working) formulas in smartsheet and the Formula errors guidance- but I am still missing it- hoping a fresh set of eyes can help me pick out the culprit. Thank you!…
-
Look up and sum costs of selected features
I am building a form and associated sheet/workflows to track requests for vehicles from our customers. I'm hoping to find a formula that would allow me to use features chosen in multi-select columns to look at a different sheet where the costs of each feature are organized, and return the total cost of all the features…
-
Updating Fields Based on Input
I have a form in which I let people enter in either a Monthly Budget or Total Budget. If it's Monthly, each Monthly Budget field obviously gets filled in with a value, but if it's a Total Budget, those Monthly Budget Fields are left Blank. Q: I know how to allocate the Budget for each month, but is there anyway to populate…