-
Smartsheet Function that Calculate Number of Days Between Today's Date and the Task End Date
Hi, I need help creating a formula to help me a couple of things. 1) First, I want to calculate the number of days from Today to the End Date of a task. 2) Then based on the number returned, I want to setup Conditional Formatting to highlight the Status column Red (0-2 days), Yellow (3-4 days) or Green (5+ days). Is this…
-
COUNTIFS(OR - Count the number of rows with a checkbox in column A, B, or C
Trying to count how many rows have a checkbox checked in column A, B, OR C. The result should be 4 (Row 1, 3, 4, and 6), but I can only get the formula to work if all 3 checkboxes (A, B, and C) are checked.
-
Auto populate based on entry in another column
I have a column "Actual Status" that I'd like to auto populate based on the "Planned Finished Date". Can anybody help please
-
Smartsheet Hyperlink to a Specific Cell in Another Smartsheet
Greetings! Seeking this team's help with the creation of a hyperlink from one Smartsheet cell to a cell in another Smartsheet. Attached is a brief example of what we are attempting to accomplish. Smarsheet A has a client list. Next to each client, we have the name of the price list the client is invoiced against.…
-
How do I automatically pull a value from a cell in one sheet into another sheet?
Hi. I have two sheets: Sheet 1 - a Work Order Submission Log Sheet 2 - a Project Log When a work order is submitted to Sheet 1, a Work Order # is generated in the Auto-Number column of that sheet. Each Work Order # is unique, but they all have the same suffix ("_wo"). I would like the Work Order # from Sheet 1 to…
-
Census Information for a company
Is there a way to add and delete employee info with an automation and formula. I need to get accurate count of how many people are in the company and what tier they fall into. I would like to have an up-to-date sheet. Updated Census Sheet
-
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?