Sign in to join the conversation:
I keep getting an error when I try this formula. I basically want to Add Contract Amount if the YR = 18 and the MO <4.
Any suggestions?
Hi Shirley,
Something like this perhaps:
=SUM(COLLECT([Contract Amount]:[Contract Amount], [Contract Date]:[Contract Date], YEAR(@cell) = 2018, [Contract Date]:[Contract Date], MONTH(@cell) < 4))
Kind regards,
Chris McKay
Hello, Im working as a consultant/developer. Im signing up with multiple clients each with their own licenses. They are adding me as I work on their project. May I know if this is possible? Will they adding me have an issue on file/sheet/workspaces view and sharing? Any tips to avoid mixing up stuff? May I know if there…
Hi, We’re encountering errors when attempting to open an update request via email. Please see details below. Could you advise on the cause and next steps? Thanks
Where do I go to make sure my Workspaces are being backed up? It seems that currently only one of our Workspaces is being backed up.
