-
=OR(ISBLANK Formaula
Hello, I am trying to build a =OR(ISBLANK formula into a text box column. Check will display is any cell is blank. I have the following formula but is displaying #INCORRECT ARGUMENT SET. =OR(ISBLANK([Producer Code(s)]@row, ISBLANK([Servicer AM/AE Codes]@row, ISBLANK([SIC Code]@row, ISBLANK(FEIN@row, ISBLANK([LOB’s to be…
-
IF Formula
My goal is to return two potential values depending on what is selected in a multi-select column (Named: [VA...DBQ Worksheet] ). The dropdowns are: Service Connected Diagnosis Blank Service Connected Diagnosis Incomplete (Rated as vs. Contention Name) Bilateral Indicator ICD Code If any of the first three are selected I…
-
6 Month Anniversary Formula
Hello Everyone, I am an excel wiz but I realize formula writing is totally different within smartsheet. I need help projecting 6 months in advance date. I used the following formula. =DATE(([Start Date]6) + 1),(([Start Date]6) - 6),([Start Date]6)). Any help would be great!
-
Calculating Actual Progress vs Planned Progress base on Today's Month & Year
With reference to the following screenshot, I am trying to capture the Actual Progress & Planned Progress on row 1 of the respective column base on Today's Month and Year. For example, today is January 2024, row 1 for Planned Progress 2 % should show 0%, and row 1 for Actual Progress 2 % should show 0%. If today is June…
-
How to use a countif formula excluding specific criteria?
Ideally I am looking to write a countifs formula to represent the reporting teams count of active task by complexity, priority, and status with the exception that the completed and back log items should not be included in the active tasks total as they are not truly active I was able to write a formula however my formula…
-
Flagging Overdue Tasks
Hi I need help flagging a blank approval if it has not been submitted within 30 days of submission. I have a Date Submitted Column and an Approval column. I have set up a Flag column and added the below formula which does not seem to be working. =IF(AND([Date Submitted]@row < TODAY(+30), [Line Manager Approval]@row = ""),…
-
Used JOIN and SUBSTITUTE to combine data in a row. Now line spacing issue
Hello, I have used JOIN and SUBSTITUTE to see which formula works better to combine data from a a row to a single cell. I inserted a HELPER command so that each data is on it's own line. The data is pulled correctly, however there are massive spaces between each line (see screenshot). Does anyone have/know a way to get rid…
-
Countif for top level ident only
Hi, I am trying to collate the number of project assigned to individuals by using the COUNTIF function: =COUNTIF({Project Dashboard Range 1}, "Colin Alexander") The problem is, that it is picking up all the names in the rows below, which are indented for the project (actions within the Project), is there a way to only…
-
How do I add one cell of data once created into another sheet?
Hi When a new row is created in Sheet A it is given an auto number. I then want to tell Sheet B that a new row has been added, or rather I want to show the new auto number in Sheet B. But only for rows where another column meets a criteria i.e. we log a certain name and so only want to send the auto number where the column…
-
Add Forumla
I am trying to create a formula to keep track of vacation time. I would like my Amount of Vacation Used column to increase by 1 everytime my Date of Day off is filled out.