# sdkotes@premierhealth.com’s Profile

points
172
Company
Contractor for Premier Health
I have worked in the healthcare industry on the software development side for 36 years. My latest endeavor is transitioning from a business analyst to a project manager.

Hello!

I cannot seem to figure out how to put together two working IF and IF(AND...) statements.

Thank you for any direction on how to accomplish.

Sandy

If I put "IF(AND..." in front of all the IF statements, only my first two statements work. The rest are ignored.

If I remove the "(AND..." from

Community:

I have tried but cannot figure out how to make this formula work. Probably something very simple, and I am overthinking.

Any guidance would be much appreciated.

Thank you,

Sandy

Scenario: Regardless of the day of the week I open my sheet:

If [Follow-up date]1 is between M - F of the

Hello!

All my sheets have automation (formulas). I am having difficulties keeping track of who has modified records.

We do not have access to sheet history because we are on the Team Plan only.

This is a huge problem because we have issues with managers not updating project status on a timely basis.

I am sharing with approximately 80 users and about 15% actually login and look at the dashboard, click on issues, risks and attachments - never mind download the attachments.

Has anyone experienced this resistance to adoption before and if so, how did you overcome it?

Thanks,

Community:

I am piggy-backing off Nathan Skyers' request from November 24, 2016 1:13 pm, regarding Parent Row Roll up, as I need a very similar formula.

Any help will be appreciated.

Thank you,

Sandy

Is it possible to have a text value show in a parent row whether all statuses match my criteria OR

Without creating another column, I am trying to update a current value only if the condition is met in my modified by field. My formula (below) works when the condition is met.

How do I tell SS to leave the current value as is if the condition is not met?

=IF([Modified By]1 = Owner1, " ",

Hello!

Is there a way to print all the comments contained in a sheet? Right now, all I can see is the option to print them row by row.

Thank you,

Good morning,

I am trying to set up a master document with linked cells across three different sheets.  First being an order form, second being a shipping form and third being an install form.

All the information will link back to my system ID of which system is being installed.

My question is

All: I have looked but cannot find other questions regarding this topic. Apologize for any redundancy; and, thank you for any help on these two topics. Sandy

Ability to Filter or Sort Source Sheet:

From my (master) destination sheet, I click cell link icon. Then, I select my source sheet. Is there a