-
Fiscal Year Calculation
Hello, I am trying to have a column that calculates a fiscal year automatically based on whether the parent Completed Date falls before or after July 1. Something that follows this logic: If the parent "Completed Date" month is less than 7 (July) display "FY 'Parent Year'", otherwise display "FY 'Parent Year + 1'", if…
-
Function to check box if lookup is true
Hi Is it a possibility where a column contains checkboxes, for a function to sit behind that that if a lookup to another sheet returns a true value, the checkbox is ticked? Specifically for the lookup to be: On Sheet1: If the value in col ID and the date in col Next Inspection Date appear in sheet2 (below) in the cols…
-
Reports Not Updating Live
I'm trying to shift our company towards using reports more, instead of multiple people interacting with sheets directly (and thus making version control difficult when minor items are changed, particularly on Control Center provisions) -- To this end, I've been given feedback about reports that indicate that they do not…
-
RAG Conversion formula
hi All, Hoping someone can help me out... -Column A is a Forecast RAG Traffic Light column -Column B is a formula that converts these RAG to a numeric value eg (R = 0 , A = 0.5 , G = 1) -Column C is a $Day Rate -Column D is a $Total Rate My issue is when I create a formula in Column D of =ColumnB*ColumnC I am presented…
-
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