-
Last Name, First Name
Please HELP!!!!!, I am trying to take someone's full name and turn it into Last Name, First Name. ex. ADAMS, JONAH = ADAMS, JONAH ADAMS, CHRISTOPHE MICHAEL III = ADAMS, CHRISTOPHE LEE ADAMS, JONAH MICHAEL III = LEE ADAMS, JONAH I was able to figure out how to pull everything left of the comma, but can't figure out the…
-
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…