-
Flag task as late where task incomplete and past due date
Please help, I am trying to flag late tasks in a column using the following formula... I am getting a #INCORRECT ARGUMENT SET error...Please help =IF(AND(Status27 <> "Complete", (Finish27 < =TODAY()), "red")) thanks
-
Error - Formulas reference too many cells
I have an automation (copy row to sheet B) that is failing. My error is attached. I investigate Sheet B, which is a large sheet, many complicated formulas, but my total count of cross sheet references is only 14. Does this mean there is a limit for the amount of intra-sheet cell references? If so, what is the limit, how…
-
Referencing Another Sheet
Does anyone know a way to reference another sheet so that you can bring information in from one sheet to another? Looking to bring text from one column in a sheet into another sheet and can't figure out a way to do that. In excel you would simply just do "=" and then select the cell on another sheet. I tried using lower or…
-
Help with (date) helper column anomaly
I am using a helper column to provide a date from 'Date created' column that auto adds date and time. The helper column date can then be used to calculate days btw it and today. I am using the formula =DATEONLY([Date created]@row) but the helper column shows the day before as in the screenshot below. I have experienced the…
-
Hi All, I have a question about COUNTIFS()
The scenario: I am trying to count only the rows that meet two criteria. This sheet tracks requests for headcount by type and by year. So there are two columns among the data, one that states the year requested, and one that states the type requested. I have two ranges, one for each column in the formula. Each range only…
-
Automatic Checkbox Based on 3 Sets of Dates
I'm trying to get a checkbox to check automatically if the day in progress is within a given month, but has not been completed in the same month and has not been placed on hold after the day in the month that it was placed in progress. Any help would be grateful!! If the project was dated as "In Progress" on 6/15/2022…
-
Count how many in one multi select column
I have an OLIT Training Column that is of multi-select dropdown type. The column is tracking who has done training on what software. I would like to get a simple count how many specific software item are in the column range. I am using the following so far but it only counts if there is only one selection in a cell, it…
-
Archiving rows with formulas that reference other sheets
I've build a pretty large Smartsheet for tracking data yearly contracts for each of my 60-70 clients on therapy caseload with formulas in each row that reference other sheets and pull numbers from daily log forms. I need a simple process for archiving a row when the year contract is complete. I want to save a snapshot of…
-
Formula for Name separated by Commas
Hello, Is there a formula that can give me all of the text to the left of a comma and all of the text to the right of a comma? I have a list of names and my LEFT FIND formulas aren't working correctly. For example, My list has names like this Adam, Smith Susan-Anne, Smith Bob, Wilson I need a First Name Column and a Last…
-
Data Shuttle Conditional Formatting?
Hi all, I had a chat with Pro Desk, and they couldn't come up with an answer for my question, so I'm turning to you all :) I have an Excel data source with project information that I receive every two weeks. One row = one project. One of three things could happen to this data source: Existing data updates Data is added as…
