sdkotes@premierhealth.com’s Profile

Community member since April 2017

points
172
Company
Contractor for Premier Health
About Me
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.

5

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.

6

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

2

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, " ",

4

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

2

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