Help with Excel formula applied to all incoming data from Forms

%3CLINGO-SUB%20id%3D%22lingo-sub-2271042%22%20slang%3D%22en-US%22%3EHelp%20with%20Excel%20formula%20applied%20to%20all%20incoming%20data%20from%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2271042%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20trying%20to%20create%20a%20database%20that%20helps%20track%20active%20and%20expiring%20certifications%20for%20staff.%20I'm%20using%20Microsoft%20Forms%20as%20my%20%22Attendance%20Sheet%22%20so%20that%20the%20data%20auto-populates%20into%20Excel.%20I've%20added%20formulas%20to%20Excel%20so%20that%20an%20expiration%20date%20will%20be%20automatically%20generated%20and%20the%20row%20will%20be%20color%20coded%20when%20someone%20is%20nearing%20expiration%20or%20already%20expired.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20far%20the%20formulas%20I%20have%20added%20only%20apply%20to%20the%20data%20already%20on%20the%20spreadsheet.%20When%20new%20attendees%20submit%20the%20Form%2C%20I%20have%20to%20manually%20apply%20the%20formula%20to%20the%20new%20data.%20Is%20there%20a%20way%20for%20the%20formula%20within%20a%20column%20to%20be%20automatically%20applied%20to%20all%20incoming%20data%3F%20Thank%20you%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2271042%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, I am trying to create a database that helps track active and expiring certifications for staff. I'm using Microsoft Forms as my "Attendance Sheet" so that the data auto-populates into Excel. I've added formulas to Excel so that an expiration date will be automatically generated and the row will be color coded when someone is nearing expiration or already expired. 

 

So far the formulas I have added only apply to the data already on the spreadsheet. When new attendees submit the Form, I have to manually apply the formula to the new data. Is there a way for the formula within a column to be automatically applied to all incoming data? Thank you in advance!

0 Replies