-
How can I add a return Blue if all these arguments are false?
IF(SUM(ColumnA@row) > (ColumnB@row + ColumnC@row), "Red", IF(SUM(ColumnB@row) > (ColumnA@row + ColumnC@row), "Green", IF(SUM(ColumnC@row) > (ColumnB@row + ColumnA@row), "Yellow"))) Thank you :)
-
Can this excel formula be created in smartsheet?
=IFS(A5>B5+C5,"RED",B5>A5+C5,"Green",C5>B5+A5,"Yellow") If anyone can help me I<d be very appreciative :)
-
Tracking time
Is there are way to track the amount of time each stage of development takes? What formula would I use and then, what chart?
-
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…