-
Why am I receiving automation email replies?
I set up an automation that will send a PO request to external clients. When they reply to the automated email it comes to my email address and not the person that was requesting the PO. 1. Does it come back to me because I created the automation rule or because I own the sheet? 2. If I sent an update request instead of an…
-
Sorting install dates in ascending order without the parent function interferring
I divided all of the PM's into parent functions and then have their jobs listed as children functions currently. One of the applications they want is to be able to filter by installer then sort the install dates by ascending order to see if there are any overlaps. However; when I enter the filter and then sort the dates it…
-
SUMIFS, multiple sheets??
Hello, I'm trying to add amounts together from different sheets based on certain criteria. I have my data divided up across multiple sheets because it is more than 500 rows. Is this possible? If so, how do I do this? My formula for a single sheet is: =SUMIFS({Dollar amount}, {Worksheet Range 1}, $ColC$14, {Worksheet Range…
-
Mark which task is the deadline?
I have a set of tasks in a schedule to prepare for a software release - which is the ultimate goal and deadline we are working towards. I want to see the critical path for this release. But, I also have some tasks in the schedule of things that need to be done after the release, and Smartsheet is showing me the critical…
-
How to write Nested IF statements each on separate line?
Hi, I have this nested IF statement that I would like to have each IF condition on a new line for easier reading and to follow coding best practices. Here is what I have now: =IF(COUNT(CHILDREN([Task Name]@row)) > 0, IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow",…
-
Enhancement Request - Parents as Criteria in Reports
I would like to have parents be used as filtering criteria in reports without 1. Showing the parent row which is generally useless and 2. The need for a helper column. Yes this is easily solvable with a helper column and the Parent() formula, but this is an ugly solution that fills up the sheet with more columns and more…
-
access rights
I need to give access rights only to certain people to edit a particular column in a unfiltered worksheet, All the info in the worksheet needs to be visible to all the members. Can this be done?
-
Index(Collect(Match)) Formula Error
Hello all, Hoping someone can help me, I keep getting a "#No Match" error for my formula. I have a neighboring column with top 5 orders and I am wanting to mirror the date that these top 5 occurrences happened (using a date column that already exists in my sheet). My formula is, "=INDEX(COLLECT(Date:Date,…
-
Auto-populating dates
I have several categories in my 'Status' column. (Sprint Backlog, Planning, In Progress, In Review, Changes, Print Files Ready, Print Req Sent, With Printing Services, Complete, Blocked) I would like to have a date automatically populate when the Status becomes 'In Review'. Then, once that date is populated, and if the…
-
Scheduling and Dispatching
I want a master calendar so I can see where our in house crew is working and other individuals so I may schedule them throughout multiple jobs. Now, we use individual sheets to gantt construction jobs. I want to find a calendar program (because SS does not have time stamp) were I am scheduling resources through out the…
