-
Additional formula logic: NOR, NAND, XOR and XNOR
Please add the other common formula logic: NOR, NAND, XOR and NXOR All these can be expressed with a combination of IF's, NOT's, AND's and OR's, but the formula gets long and difficult to follow—it's not as clean. And don't get me started on when you have long phrases as column headers to use as variables! Right now I can…
-
INDEX/MATCH formula broken after number passed 100
I have been using an INDEX/MATCH formula to identify entries from one sheet to another. I used an automatic numbering system starting at 000 to index/match. If there is no match, then the formula returns a blank cell. Entry # 100 was deleted out of the sheet due to an error and after that the INDEX/MATCH is no longer…
-
Need Help with Modifying an IF/OR Statement to add an AND condition
I have a column I recently created in a sheet to help our team know if they are missing information in a critical field before they move on to approvals (Critical Fields). I used an IF / OR statement to look at all of the critical fields and determine if any of them are empty. If one is empty then the field (checkbox) will…
-
Control Center and Contact Columns
I am using control center to create projects. In the sheet that gets provisioned, I have my resources listed. I want to bring the "Lead" contact back into the Intake sheet, but it is coming back as just text and not an actual Contact. We use the Current User view for project updates, which won't work this way. Any ideas on…
-
IF formula is not working as expected
I'm sure I'm doing something wrong with this formula, but I can't figure out :( Any help is much appreciated!! I'm trying to add a text to the column "Dispute", so if the # of days in the "Days from Audit" column is equal or higher to 10 text will be "Dispute not applicable" or if the # of days in the "Days from Audit"…
-
Week over Week (or MoM) Automated Results
Hello Smart Heads! I hope you are doing great! This time I have a question about semi-automated WoW (week-over-week) calculation for specific performance metrics. Thats how it looks as for now: In WoW for SLA I have: =IFERROR(([W03]@row - [W02]@row) * 10000, "") below I have also formula for % change: =IFERROR(([W03]@row -…
-
Total Price for multiple selections
I have an order form that has a drop-down column. Within that drop-down, you can select multiple things. I have a total of 35 items. How can I have Smartsheet total the cost for the selected items? I have another sheet with all the tooling and cost.
-
Broken SUMIF Formula - Sum of column based on info in another column
Hello everyone! I am currently attempting a SUMIF equation that initially worked and is now broken. Here are the parameters. I would like the sum of the dollar amount in this column "FY24 Adopted Budget" to show in a cell in this column, "July Expenditure" based on the information in these columns "Cost Center" (Dropdown…
-
using OR function with long formula
I have a "ledger" sheet that I use to calculate real-time budgets based on any changes and shifts that come through a request system. Currently, it's built for F24, however as we move towards F25, I want to add in options to include F25 budget change requests/shifts. In order for my sheet to calculate correctly, I need to…
-
Return a value from a cell based on today's date
Hello everyone, I am creating a metric sheet to track the total hours, attendees, and person hours of meetings and would like to track it based on today's date. In the example above, I would like to use TODAY() in the top row under the "Date" column. Then if the date in the rows below are in the past, return the…
