Formulas
Discussion List
- =SUMIFS(Mission:Mission, [RLO Receive Date]:[RLO Receive Date], ≥TODAY(-360)) Not sure what Im missing here? Anyone had any advice?
- Hi There, I need assistance on ItsBlank formula. Formula I currently have that isn't working =IF(ISBLANK([Other Concerns]@row), [Name of Company]@row + "presently had no other comments or concerns.").…
- When I transfer completed orders from the working sheet to the archive sheet, I encounter a formula error in calculating the final stock. Before moving the data: =[Initial Stock]@row - SUMIFS([Total Q…
- I am trying to use INDEX (COLLECT) to match information from two columns to turn out a result in the third column. This is just a demo (actual variables are different) but here is the general format I…
- Hi, I'm stumped on a formula and hoping to get some help. I have 2 sheets; Sheet 1 is titled E&I and contains the tag number and Sheet 2 is titled Open PO's and contains the date the item is due and t…
- Hello Community, I am currently creating a knowledge check and was wondering if there was a formula to create an "all that apply" type of question. For example: 5. What is on the customer experience c…
- I'm fairly new to formulas. I created this one sucessfully so far: =IF(AND([Contract Status]@row = "Existing Contract", [Credentialing Status]@row = "Approved"), [Credentialing status: As of date]@row…
- Hi All - I'm needing to convert Text to Number as intermediate step for another formula column in my worksheet. Have successfully used VALUE Function =VALUE(LEFT(Probability@row, 2)) This will work gr…
- Hello, I have been using a symbol column to monitor updates for a master sheet of all of my departments projects: =IF([Exec Summary Update]@row < TODAY(-14), "Red", IF([Exec Summary Update]@row < TODA…
- Hi community. I am working with @Laura Polson to help our field staff be able to track their schedules while out visiting stores for various reasons. We would like to find a way to show visibility bas…