-
help with dates in an IF statement
Hi Wonderful Formula Wizards, I am using the below formula to calculate the number of days an employee is working in a temp assignment - I just found out these employees' assignments can be paused (due to injury or vacation, etc.) and restarted. This means that I need to add the following columns and include the pause and…
-
Sum Row with Current Month for Metric Widget
I've search and tried this so many different ways but cannot figure this out. Basically, I want to create a Sheet Summary Field that totals the row for the current month. I thought creating a helper field and index formula would do it - but can't get it to work for some reason. I think I've over complicated it, honestly.…
-
Adding a secondary match option if the first one is blank
Currently we have a new inventory system which consists of a Master Sheet (contains stock counts for 3 office locations) & a Check In/Out sheet (which has a form for each location). We were excited to utilize the Barcode Scanning feature but unfortunately have discovered not all products have barcodes. Due to this we have…
-
FORMULA IF ISBLANK
I have a column called "Price" and a column called "''''Became a Lessee". I need to populate in the "Price column. If the "Became a Lessee" is blank, the "Price" column needs to stay blank. If the "Became a Lessee" is before 01/01/2021, the "Price" column needs to say $2500. If the "Became a Lessee" is equal to or after…
-
formula sheet and editing
Good afternoon, My manager recently became a licensed user and transferred all of our existing sheets into her name and assigned me as an admin. I am having difficulty with linking the tracker to the formula sheet and even as admin am unable to edit the dashboard to link to our current tracker/formula sheet. I welcome any…
-
Validating data input in a Form
I have set up smartsheets to collect data with forms for the users at our facilities. The operators check equipment and enter the data in the form. Sometimes, they fat finger it - or forget the decimal point which causes an out of spec condition and email notifications. Is there any way to validate the data and the user…
-
Hyperlink cell value connecting to a specific sheet row
Hi, Would be really helpful if someone can suggest a solution to my below scenario: I have multiple projects in my program, I have a sheet which contains release names which is connected to task name project plan within program. I want to have a hyper link from my current cell to specific project task name. For example, In…
-
Counting Status of Requests for CURRENT Month
Hi, I want to create a formula on the request metrics form that counts the number of requests "not started", "in progress", and "completed" within the CURRENT month. My column for the status' is named "Status". Please assist. Thanks! Jodi
-
Running total (sum everything above or below)
I am trying to create a running total where each row is a separate order. The order has a column for cycle time and another column for cumulative time where it sums up all of the cycle times of the orders before it in line. Ex. an order submitted through a form goes onto row 50. It has a cycle time of 10 min, and also…
-
SUMIFS
I am trying to use the sumifs to get the total of amounts that have been paid based on certain categories but need to exclude certain submitters The way I have tried it is below. =SUMIFS({Paid to Date},{Category}, OR("Type 1", "Type 2", "Type 3", "Type 4"), {Submitted By}, OR("Name 1", "Name 3", "Name 5")) I have thought…
