-
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…
-
How to count reference stored daily to a sheet storing weekly.
I have a sheet that stores records daily (several per day) of installations categorized as either "Res" or "Com". I'm trying to count the "Res" category above based on week ending dates (Sat) below in "Meters Installs Actuals (RES)". So for Week Ending 01/14/24 the formula would count all Res from 01/08/24 to 01/14/24.…
-
Index/Match not working when the Match column in source doc is a 'RIGHT' formula
I have a column in my source sheet where Store # is a RIGHT formula. When I index match in my Target sheet I get 'NO MATCH' when trying to find Store #.
-
Avoiding Overbooking using Smartsheet Calendar/DataShuttle
Hello! I am trying to create a booking system for a room with multiple stations. Stations: 1 - 5. Time slots: Morning, Afternoon, All Day So far I have a dashboard with a calendar/form and separate sheet for the form submissions. With the calendar, people are able to see other bookings, but ideally, I want to use…
-
Formula for This week, Next week, etc.
Someone helped me with these, but I cant get them to work. Can someone let me know the error of my ways? This formula would be for last week =If(YEAR([Projected Start date]@row=YEAR(TODAY(-7)),IF(WEEKNUMBER[Projected Start date]@row=WEEKNUMBER(TODAY(-7)),1,""),"") This formula would be for this week =If(YEAR([Projected…
