-
Summary
I am trying to find a way to do a monthly summary of the number items each month in Published, and Expired Alert Status. Does anyone know what would be the best way to complete this? Thanks!
-
Attempting to add a column to report that is under Summary task
I have a sheet of active projects. I am trying to create a report filter on the Status column. However Status does not show up as a column either in row report or summary report. The first task is a summary task and all other tasks below are children.
-
I don't want grid lines to display on my dashboard. Can these be removed (or made not to show)?
Using the Employee Contact List - Template Set, I have created an employee contact list, with reports broken out by teams. When I add the reports to my dashboard, the grid lines show. Is it possible to remove the lines so that just the text shows? Thank you! Pam
-
Recommended Trainings to learn formulas? Beginner to Advanced
Hello! I went to Engage19, participated in all formula learning sessions and have even seen the recordings of Engage18. With this I've just been exposed to possibilities and have applied them by copy pasting the formulas, but I don't really understand the logic of it to actually be able to build my own or think of…
-
Parent vs child flag
Hello, I'm wondering whether it is possible or not to write a formula to indicate whether a certain cell is a parent or a child. The sheet I'm working with only has 2 levels, and I'd like to create a column that is able to delineate the two. My initial thought is something along the lines of =IF([Cell 1] = CHILDREN(), 1,…
-
Update Forms: Can they be created without the automated email link generation?
I have an intake sheet with multiple projects and instead of sending a project manager an automated email with a link to an update form to change any information regarding a project, is there a way to have a form be a standalone link in the intake sheet that when clicked opens up a form in a new tab. From there, the user…
-
COUNTIFS based on Children criteria of certain row
Context: Please see screenshot attached. Project Manager "Fred" has 2 "active" projects in January: Project 1 and Project 2, which are Children under "Fred". This count of 2 is determined by some percentage of the project being completed. Goal: Count the number of active projects per month based on % complete being greater…
-
HELP
Excuse me, my english isn't very well. I need your help. When I want to put an URL in smartsheet I click in the box to join an URL and on my mouse but nothing are been proposed to me (cut, copy etc). My mouse works very well except for that
-
Checkmark Parent if any Children Due Date is in the next 7 Days
Hello! Stuck testing out formulas to add a Column [Children Due Soon] that checkmarks if a parent row [Task Name] has any children task is due [Due] in the next 7 days. I've been trying to edit the famous RGB formula for this, but still not very familiar with formulas. Thanks!
-
Using IF, AND, OR
Looking for formula advice/help! I would like to write a formula that will: Mark Past Due if Complete By is greater than today + task is not complete If no Complete By date exists, than Past Due flag remains unchecked So far, I've been able to create a flag based on the first bullet, however-- tasks that do not have a…