Best Of
Re: Select specific person/email as the name for automated alerts
I also echo most of the sentiments that have been conveyed with regards to this request. We currently maintain a weekly reporting solution using the email alert automation, which takes data from a sheet row and emails it to a given group every week. Right now, we have had to resort to making the send-as user (in our example, a PM) the owner of the sheet, to allow for at least a more direct reply-all solution.
What would even make it more expansive would be to allow for addition of a list of emails within the reply-to field as well, so replies could go to multiple users, rather than just the individual owner of the sheet (or a singular custom address). This could be paired with the request from the attached request to make a more expanded email reply-to and naming customization scheme for email alerts.
Re: Form submissions not showing on sheet
Hi,
I hope you're well and safe!
If all the activated rows except for the last that is populated are deleted, it should add to the next available row.
Doesn't that work?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Re: Form submissions not showing on sheet
I ran into this same problem yesterday/today. I am helping a colleague with a sheet/form he created, but when I added my new entry via the form, I wasn't seeing it. It was at the way bottom of the sheet, after like 50 blank/empty rows. So I'm guessing the owner of the sheet clicked in those rows or did something where the form input thought there were valid records. Glad it wasn't something more major, I was thinking we may have to recreate the form, which would have been less than ideal.
Re: Form submissions not showing on sheet
Many thanks for your help with this, sorry I was being silly and not looking down far enough. I did not realise I had blank rows in the sheet.
Re: Multi-factor Authentication
I got an email last Monday 3/15 that by the end of April they will have instituted email-based TOTP authentication. I have their business plan, but my hope is that this is for all versions. And that sometime after June 1, they will be retiring the traditional password-based login method.
Re: Export to MS Project (XML) - Greyed out
MS Project export is tied to view. Switch to gantt view and try to export it again, the option should be enabled.
Hope this helps.
Re: RGBY formula
Hey @jgneely72151,
You will want to use an IF/AND statement for this:
=IF(AND([EPEX Face Page]@row = "Green", Budget@row = "Green", [Budget Justification]@row = "Green"), "Green", "Red")
Hope this helps!
Re: Making Column auto select options based off what I put in another column
You could create a second sheet with the information. Then use an Index match on the original page to pull the information
Re: Making Column auto select options based off what I put in another column
yes it is a formula. It’s like a better vlookup
Re: Mastering Parent-Child Row Relationships: Solving the '#INVALID DATA TYPE' Dilemma in Health Status
Try this:
=IF(COUNTIFS(CHILDREN(), "Overdue / Risks") >= 1, "Overdue / Risks", IF(COUNTIFS(CHILDREN(), "Some Risks") >= 1, "Some Risks", IF(COUNTIFS(CHILDREN(), "No Risks") = COUNTIFS(CHILDREN(), OR(@cell = "", @cell <> "")), "No Risks", IF(COUNTIF(CHILDREN(), "Canceled / Done / On Hold") = COUNTIFS(CHILDREN(), OR(@cell = "", @cell <> "")), "Canceled / Done / On Hold", "Some Risks"))))