-
Automated Reminders Based on Approaching Due Date
Hello Community, I am attempting to produce an "if/then" statement within a column of my project management smartsheet in order to create an email automation to remind the assigned user to address the aging task. Using the formula, I should be able to create conditional formatting or email automation workflows that address…
-
Pull information from report to sheet
Hello, I have a template that my team uses for data collection each time we get a new lot of diagnostic tests we need to quality check. In one folder, "data collection forms" there are many sheets, as each lot gets it's own sheet. New lots are tested every day, so the sheets in this folder are constantly being added to. We…
-
Formula Help w/AND
Hello Community! I really struggle with formula syntax. Here is what I'm trying to do. I have a project plan and when certain milestones complete, I want to count the actual "widgets" I completed. My project plan has multiple phases so the completion of each phase adds more widgets to the bucket and I want to reflect that…
-
Formulas for auto creating start time / end time based on duration - Event Runsheet
Hi, I am wanting to create an event runsheet. I have a formula that automatically calculates the duration from start time / End Time but Im having trouble figuring out how to automatically calculate Start Time / End Time from Duration which is more Ideal. I could enter a Start Time & End Time in the parent row and then in…
-
Looking for help with countif formula
I'm having some trouble with a countif formula, looking for some assistance. My goal here is to count the number of time the Created Date is last month and that the service type is "Trade Database - Add Part Number(s)" When I enter the formula below it works great! =IF(MONTH(TODAY()) = 1, COUNTIFS({Genie Archive Created…
-
Calendar View - can't drag tasks when Due Date uses WorkDay function?
My SmartSheet has Task Due Dates that are calculated using the WorkDay function. For example, if a recurring monthly task is due on WorkDay 1, that calculated Task Due Date would become Monday, January 3rd, rather than Saturday, January 1st. Approaching the dates in this way makes it easy for us to rollover the Task List…
-
Formula to pull data from one sheet into a different sheet.
Hello Smartsheets, I am building a sheet that will track an employees attendance of our monthly trainings. Sheet #1 is the raw data, Sheet #2 contains all of the formulas and combines all raw data in a legible way. See photos below. Sheet #1 This sheet contains all raw data received from the attendees of each monthly…
-
How to count number of vendors in each country?
Hey Community, I am simply trying to calculate the quantity of contracts assigned to each vendor per country (Ex: I want to see that IBM is covering 100 contracts for us in the United Kingdom). The columns I have to use for this are the following: Vendor assigned, Covered Country (on the same sheet) Countries, Vendors (on…
-
Achieving Optimal Index-Match Performance
I'm wondering if anyone has any insight as to whether or not Index-match works any faster when the fields being used in the look-up contain numbers only, instead of text or text/number mix? In my own anecdotal experience, sheets that use index-match on numbers-only columns do seem to open/update/save faster. But I have no…
-
RYGB Lights Not Changing with Dates
I am not sure why my lights wont change based on the dates: =IF([Original Due Date]@row < TODAY(14), "Yellow", IF([Original Due Date]@row < TODAY(7), "Blue", IF([Revised Due Date]@row > [Original Due Date]@row, "Red"))) Would like: Yellow: <14 days from today Blue: <7 days from today Red: Revised Date < Original Date