Sign in to join the conversation:
I would like to have the parent row of my health column automatically be red, green or yellow based on the average health of it's child rows.
Does anyone have an idea of how to accomplish this?
I replied on your other thread about this.
My goal is the bring in contact information (Name and email address, 2 separate columns) from a reference sheet {Sheet A} to my target sheet {Sheet B}. I've used {Sheet B} as a reference on many other sheets for the same purpose, however, the data on this particular target sheet is inconsistent with the reference sheet.…
All, The way my Smartsheet workspace works: Every time the Status column of a particular request in Master sheet is changed, the entire row is automated to be copied to Status Tracking sheet. The change is timestamped as Change Timestamp and the Subsequent Timestamp is recorded in Status Tracking sheet with every…
Hi all, I’m looking for advice on the best workflow to manage inventory deductions. I currently have two sheets: Sheet 1 (Master Stock List): Contains hundreds of items, locations, and catalog numbers. Sheet 2 (Weekly Usage): Operators log items used during the week by scanning QR codes. Currently, Sheet 1 uses a SUMIF…
