Sign in to join the conversation:
i have 2 sheets to reference
first sheet has a confirmed check box column
but on another sheet i want it to check a box as a pilot user if the confirmed was checked...
is there a way to do this with a formula?
Hi,
The simplest way would be to use cell-linking and link the checkboxes.
Would that work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
=SUMIF({Stores Daily Log Range 8}, "1000000456", {Stores Daily Log Range 9}) Hi I am adding figures from the above sheet to another sheet using criterias. everything works until I add another line in the log then the Range does not automatically pick up the new line. Is there a way to do this please.
I have three columns that I want to compare. I thought an If(and( statement would do it but I keep getting #incorrect argument or #unparsable errors. Each column is a dollar amount and I basically want if Column 1 < Column 2 and Column 3 return a value. Below is the expression I've been trying. =IF(AND([EXTENDED COST…
I am trying to find the next upcoming Date and its associated Task based off what activity is being performed and where it's taking place. The formula I have to find the next upcoming date works perfectly: =MIN(COLLECT({Date}, {Date}, >=TODAY(), {Activity}, ="Activity ", {Area}, ="Area")) My problem is trying to get the…
