-
Formula to match Payment Terms to a number (Nested If Formula)
Hello, I am trying to match a number based on the value of Payment Terms. For example if Payment Terms if NET 30, NET 45, or NET 60 I want to make a formula in a separate column that match the number portion. For example Net 45 should become 45 in a separate column. My formula only seems to work if the Payment Terms is NET…
-
Help! COUNTIFS function with 3 criteria
Hi! I'm having trouble getting this COUNTIFS function to work, getting the error "incorrect argument set". What I have: =COUNTIFS([Due Date]20:[Due Date]3443, <=TODAY(-7), [Assigned To]17:[Assigned To]3440, <>"", [Task Completed On Time?]16:[Task Completed On Time?]3440, "Yes") What I want it to do: Count rows that meet 3…
-
Basic Formula
How can I write a working formula to count number of all cells in a column (excluding blanks) of a different sheet that don't equal a certain date? Example: COUNTIF(Referencedsheet_ColumnName(all but blanks), <>"12/20/1900") Thank you Sorry it is too basic but I am a beginner.
-
Returning date either 15th or 31st of the month
Do we have a formula for rounding off dates to either 15 th of the month or 31st of the month? for example if the date falls between 1-15 of a month, I need 15th as the date for that month and year. and if a date falls in between 16-31 then it should return 31st of the month and year. Kindly advise. thanks for your help.
-
Automation
Is it possible to include functions in workflows??? For example, everyday @ 11pmEST, I want any rows that have "Completed" checked AND that are 60 days old or more from that days date, to move to another smart sheet. Please advise if able.
-
Dates formula : add several months in a formula
Hello everyone, I have a small question about the use of Smartsheet for a formula on dates. Here is the use case : I have a column with a date. I would like to have another column with a formula that add 3 months to that date. I already try =DATE(column)+90 but it only add 90 days and sometimes 90 days is not exactly a 3…
-
Drop Down Multi Select Formula
Good afternoon everyone. I am trying to figure out the best way to build an "IF" type formula from a multi select column. The formula I tried was: =IF([1. Line of Coverage]@row = "Voluntary Life/ADD", 1, 0). This would put a star in a column to illustrate that a document needs to be collected. This works as long as only…
-
COUNTIFS OR Function Error
Hi, I'm attempting to create a formula that will count the number of requests that are pending review. The column uses a drop down menu with three options, Submitted, Approved, or Declined. I'm trying to create a count in the Sheet Summary to count the number of requests that are still pending approval. The options that it…
-
Percentage complete to feed from text option in single select dropdown
I would like the % Complete to feed from a drop down list of the following options Not Started (0%) In Progress (50%) Waiting for Review (90%) Complete (100%) I'm stuck on where to even start that one. The options are coming from a drop down column that is single select and limited to those options
-
Counting Items mentioned once in a multi drop down option
How do I have on a tracking sheet where as long as the item is mentioned in a multi choice cell, it counts that item I am requesting? "At Risk Associate" needs to show 4 times, but doesn't show anything. I use COUNTIFS and tried HAS but nothing has worked.