-
Formula showing #invalid operation after changing a simple logic
Hi all, it's me again! So I've got this formula that breaks down hours by duration into relevant months and somehow I can't get the syntax right. What I'm trying to say is that if Global lead at row = "EU" , use lead startup and "Duration (months)", if global lead at row <> "EU" and Regional startup date is not blank, use…
-
How do I concatenate text in a different sheet and a changing number
Hi. I need to concatenate text and year that are stored in a different sheet and get the result in a second sheet so that the year number changes depending on what the year is For example : if I have the base year 2022 in Sheet 1 The concatenated texts in Sheet 2 should look like this " Calendar Year 2020" and "Calendar…
-
Conditional Sheet Population
Is it possible to use conditional formatting or formulas to suppress unnecessary tasks? And, if so, could Smartsheet adjust dependencies for removed tasks? For instance, we have a sheet to track product implementations; however, some products are not elected by a client and therefore we do not have to track their related…
-
COUNTIF Across Multiple Sheets
Hi All I am trying to get a count on total number of overdue items on a different sheet by project manager. I have tried multiple variations of the below formula but have yet to find one that works. =COUNTIF(AND({Data Range 1}, CONTAINS("Carolyn Kuo", @cell), {Data Range 1} = "Carolyn Kuo")) =COUNTIF({Data Range 1},…
-
Data Shuttle Workflow Filter for Blank - Empty Cells
I am using Data Shuttle to import data from an Excel file to a Sheet. I would like to exclude rows from the workflow where an identified column is blank or empty. I thought it would be simple, but the statement below is not filtering those rows. It must be something simple I am missing.
-
Error when using multiple SUMIFS in one column
Hi . I am trying to find the sum of each group of 5 rows using SUMIFS in Column 1 where the employee's name is John Smith (in cell 3 in Employee Name's column) and the status is Full-Time (in the Status column). =SUMIFS([Column1]:[Column 1], Employee Name: Employee Name, Employee Name3, Status:Status, "Full Time") The…
-
Joining multiple select columns into one column
Hi, I have 2 columns that are multi-select and one column that a text column. I am looking for a formula to be able to get them all in one multi-select column. I want multi-select column Missing 1 and multi-select column Missing 2 and text column ID problems to all combine in the multi-select column Missing. I used the…
-
IF formula for a cell that is not colored and blank
Is there a IF formula where I can check off a box if all the cells in a row that are not colored are filled?
-
Count if project is starting within the next 30 days
Hi, I'm trying to count how many projects will be starting within the next 30 days. I understand I can filter, but i need to run a report and I'm having difficulty with my formula. I'm fairly new with formulas. I continue to receive a "unparseable" error" . Any help would be greatly appreciated. Thank you in advance.…
-
Is there a way to not type DATE formula manually?
I have a sheet with the date as the column name and have a cross-sheet formula with SUMIFS and DATE. Is there a way I don't have to type the date manually? Unfortunately, I have over 100 columns that I need to modify the date to match the column 😥 You'll be a lifesaver if there is a way! Thank you in advance!!🙇♀️