Victoria_Indimar
Victoria_Indimar
Reactions
-
Re: Form Automation- Request an Update
Hi Craig / @DPS Finance. For your first issue, the approval workflow is only triggered when a new row is added so if it is declined and updated, a new approval would never be trigger because the row …1 · -
Re: Count Number of Tasks
To add to a dashboard, I typically create a separate summary sheet that rolls up the information you want to generate a chart/graph from. For example, I see you have Milestones to organize your tasks…1 · -
Re: COUNTIF/S Sheet 2 has "Auto Doors" in dropdown
Hello and welcome! If your Program list in Sheet 2 is written out to match the option in your form and entries in Sheet 2, then you can just reference those for look up: =COUNTIF({Task Request Range …1 · -
Re: CountIFs - 2 Critieria in another referenced sheet
How about this? =COUNTIFS ({{Sheet 1: LOCATION}, LOCATION@row, {Sheet 1: YEAR}, NOT(ISBLANK(@cell)))1 · -
Re: combine vlookup formula in one row
Hello! Yes you can combine the output of those two formulas in one cell. It'll depend on how you want the combined result to look but you could do something like: =VLOOKUP(example) + " - " …1 ·
