-
IF Statement needs to ignore blank cell sometimes
Sometimes there are two approvers, sometimes only one. If there is only one and they "Confirm", I record a date column otherwise not and my workflow runs. Sometimes there are two, if they both need to "Confirm" and then I record the date column. If either rejects I don't record the date and run a workflow. The problem I am…
-
Previous Month formula
Hi I'm in the process of creating MTD and Previous MTD helper columns. If the Create Date is current month, I want to check a box. I have this formula working perfectly. What I'm struggling with is previous MTD. If the Create Date is the previous month, then check a box. If the Create Date is older than previous month,…
-
Formula Help
Hi - I am trying to create a formula that shows the conditions of: Tasks due within the next 14 days that are not equal to the status of "Complete" or "not Required" I am looking to do this on as a summary total on the project sheet. Thank you for the help!
-
COUNTIFS and DISTINCT formula error
Hello! I am trying to count the number of unique customers from one column, that have been flagged with the year 2022 which is recorded in a separate column. Formula I have is - =COUNTIFS(DISTINCT({Customer Name}, {Financial Year}, "2022")) I am receiving the error, Incorrect Argument Set. Can someone help please?!
-
Contains If Returning Incorrect Argument Set
Hello, I created this formula: =COUNTIFS(CONTAINS("2009", {Protocol #}), {Amendment}, "0") To review a list of Protocol Numbers (column) that contain 2009 (the year, part of the protocol number) and are not amendments (column of check boxes, want those that are unchecked). I tried a variety of versions of this, but this…
-
Copy column on one sheet to another column on another sheet (and update when new rows added)
Is there a way in Smartsheet to have Column A in sheet 1 automatically copied/linked over to Column A in sheet 2? We need consistent building names across 12 different sheets, but we want Sheet 1 to be the only place new building names are added. Is this possible?
-
How do I score out a survey and have it populate in another column?
Hi everyone , I am attempting to create a scoring system for a survey based on this type of scoring below. These are the survey questions and it already built in a sheet. Thanks in advance for the support.
-
Compare submissions
Hello! I would like to compare submission such that older submissions from same field "Name" are moved to different sheet. I can add a helper column called "Older" and would like to either populate the older rows with the word "Older," and number to signify it is older, or a simple yes/no dropdown. I currently have a…
-
Sheet Summary - same sheet VLOOKUP with TODAY()
Hi, My Column Headers are: Date, Total Opened Cases, Total Closed Cases, Total Backlog. I am attempting, and failing, to use the following variations of a VLOOKUP formula. Can someone help?? =VLOOKUP(TODAY(), {Date}:{Total Backlog}, 4, false) = #UNPARSEABLE =VLOOKUP(TODAY(), {Date:Total Backlog}, 4, false) = #INVALID REF…
-
Nested IF/AND/OR
I'm modifying a formula used for status tracking and I'm running into an unparseable error that I'm having problems resolving. I want to make the status red (stop sign) if the status is "in progress" or "not started" when the "at risk" column is checked. My understanding is that the formula will look for the first true…