-
Nested =IF() Issue - Logical statements are being interpreted wrong(?)
I'm having an issue with the Logical Statements when using nested =IF() statements. Essentially, it's not following the Logical Statements correctly. Here is an example of a formula that is failing: =IF([Surplus]@row = [Deficit]@row, "No Variance", IF([Surplus]@row > [Deficit]@row, (([Surplus]@row - [Deficit]@row) +"…
-
Merged: Editable column formulas
This discussion has been merged.
-
Change date format
Hello! How do I change the way a date is displayed? I need to change dates displayed as ""yyyy-mm-dd" to "yyyymmdd" for a report. Thank you!
-
Next Expense Date Formula
I need to create a formula that will find the next expense date based off 3 other column categories. The columns and their categories are as follows: Due Date (single date when expense is due), Program ( Men, Women), and Budget Impact (Income, Expense). For this formula I need to find and return the next expense date from…
-
Merged: Formula's to have a user input result
This discussion has been merged.
-
Linked Source Sheet Not Automatically Updating
Hello, I am working on creating a sheet that utilized data from a master sheet via links. I am struggling because the new sheet is not automatically updating when new info is added from the master sheet which essentially makes it useless. Is there a way around this? For what I am trying to create, I need the full…
-
How can I capture the date and time of specific column changes?
I have created a workflow that goes through three different departments. I want to capture the date and time of a request (row) coming in, and the date and time of the next action and each action after that for cycle time purposes. Currently, I can track cycle time for dates but some actions need to be carried out within…
-
How to create a master sheet that can work-around the 20,000 row limit?
Hello Everyone! I need to consolidate data from two large Smartsheet sheets into one master sheet to use as a reference for another sheet. However, Smartsheet's 20,000-row limit prevents me from combining everything into a single sheet. I cannot use Smartsheet Reports as a workaround since reports do not support formulas,…
-
Calculate Age from Birthdate
Hello, How do I calculate a person's age from their birthdate?
-
Keeping Indexed and Non-Indexed Columns on the same Row
I'm making a training matrix for my company. Source sheet is the "matrix" that will list all employees and their required trainings: *RowID is auto-numbered column *RowNo formula is =MATCH(RowID@row, RowID:RowID, 0) *E1 (helper column) formula is =COUNTIFS([Employee1]:[Employee1], [Employee1]@row, RowNo:RowNo, @cell <=…