-
Trigger a daily automation if a record doesn't exist
Hi there, Our warehouse leads use a smartsheet form to upload a document once a day, around noon. I want to have a notification sent to the manager of a warehouse if that warehouse didn't upload a file for that day. The sheet that the form is built on looks like this: DC is the warehouse number. The formula works for…
-
Nested IF / THEN / SUM Formulas - Based on Values in Drop Down List
Hello! I am working on a Commission log and tracking project. The commission amount is based on the amount billed which is contingent on the contract billing cycle rather than the total cost of the sale. So, I am trying to create a formula that will calculate the billing amount based on the bill cycles from a drop down…
-
Receiving error when using If/And
I have a sheet with the following columns, Date Opened, New - Review Date, Working Date, Alert column, and Status. New-Review and Working Dates are automated by the system when the Status changes to one of those options it records the date. I am trying to write a formula to fit the below scenarios: If one day has passed…
-
How to eliminate false counts on created date (auto-number deleted line items)
Hi there, Thanks for helping with this. I'm creating a sheet summary formula that does a count of items created within a specific year. All good there. =COUNTIFS([C-Year]:[C-Year], "2022") The wrinkle is that the sheet has autonumbering and so I'm getting a false count with 4 items that were created and then deleted. No…
-
Can a report automatically update (add rows) as the sheet behind the scenes is constantly adding cel
Can a report automatically update and add the rows that the sheet it is being used on? My sheet is constantly being added to and I would like the report to also add the cells when the cells are added in the sheet.
-
Calculating averages based on specific criteria per week.
I have a smartsheet that I am trying to find an average rating per week if there is specific criteria in a column. I've condensed the columns I'm trying to find an average of below The 'Created' column is an Auto-Number column for when the data is entered. I'd like to calculate the average, or 'Over All Rating' for each…
-
Floating dependency start dates
I have two dates: A and B. B's start is dependent on A's completion. If everything goes as planned, A will finish on 2/27 and B will start on 4/1. B's start date is constant unless A's finish is delayed beyond the planned start. For example, if A is delayed until 3/15, B will still start on 4/1; but if A is delayed until…
-
If it's blank, Red Symbol. If it's not blank, Green symbol.
I'm trying to get this formula to work correctly. =IF(NOT(ISBLANK([Link to ARP plan]@row)), "Yes", IF(ISBLANK([Link to ARP plan]@row)), "No")) It's not working. Any thoughts?
-
Using Contact List data in IF statement in Sheet Summary
I'm working on a system of sheets to track requisitions within our Talent Acquisition team. I've built out a helper sheet designed to help us track the average requisition priority ranking that each recruiter has. Since this is a helper sheet, its only purpose is to gather this metric, so I don't care what the sheet looks…
-
Nightly Automation with Today Formula
I seem to have a 'ghost' in my sheet where only half of my automated workflow seems to work on any given day. My sheet (called a playbook) has half of the rows with =Today() date formula, and the other half with a hard-coded date; each night at 11:00pm PST my worflow copies the Today rows to a 2nd sheet (called a tracker)…