-
Re: Forms with Workflow
Yeah, umm... this is really simple. You need to get familiar with the 'Forms' & 'Automations' on a sheet. Basic IF formulas should work for status changes. :)1 · -
Re: Report on tasks for the next 3 weeks
Hi, I just think you have your criteria confused right? You could use- Criteria 1: start date is before today AND end day is after today OR Criteria 2: start date is before today +21 Does that work?1 · -
Re: Trying to get a formula to analyze 5 columns and update a 6th column based on the results of the 5
Its just a big nestled if statement. i.e. =IF(OR(col1@row="Red",col2@row="Red".......),"Red",IF(OR(countif(col1:col5@row,"Yellow')=1,countif(col1:col5@row,"Yel…1 · -
Re: Wanting to migrate from outdated software
Hey!! I like to build summary columns to summarize multiple fields in form solutions. I find some of the below functions really useful for that. Alternatively, you could consider using document build…1 · -
Re: Good examples of assembling project budgets using forms
Yeah.... kind of. I have lots of questions though. Are there multiple line items assigned to different resources in your estimate? Can you confidently set a maximum number of resources used for the s…1 ·