-
COUNTIF Not Counting Accurately
Good Evening, OBJECTIVE: To count every instance that has been selected with each cell for multi-option drop down Column AGE DISTRIBUTION. I have attempted the following formula's but neither will count all the instances throughout the column or it only outputs #UNPARSEABLE: Thanks taking the time to look at my problem,…
-
Simplify large if then statement.
Hello I have a large portfolio of projects. Each project can be in one 10 or so phases, and each phase can have 1 to 3 or 4 milestones during or at the end of the phase. I am trying to develop a sheet that will look at a project and the current phase, and confirm that the next milestone forecast makes sense. The challenge…
-
Show tasks that are happening today in a report
Hey! So, I'm on a construction company, and I need to make a report that shows the tasks happening today But I don't know how to show tasks that are not starting or finishing today, but are still in the process of completion. With these filters, if a task started yesterday and is finishing tomorrow, it will not show on…
-
Count entries per month and year
I have a dashboard that displays entries per month. Now that we are in a new year, I would like to separate the entries by month/year to do a rolling year display on my dashboard. My formula keeps coming up as unparseable. I'm counting the data in the Created Date column on another sheet. =COUNTIFS({Operations Escalation…
-
Circular Reference Error
I am trying to create a formula showing the utilisation of my Project Managers based on hours against projects and PTO vs. their full time contract hours. I am using the following formula for Project Manager 1: =SUMIF(Person:Person, "PM1", Aug:Aug) / 140 When I apply the same formula for PM 2 (substituting PM1 name for…
-
COUNTIFS + FIND FORMULA
Hi I need help with the below formula please? I would like to return values that have Triage, ARB Approval, Business Case, FinRev Approval and CIC Approval selected =COUNTIFS({Tech Lead}, FIND(Metric@row , @cell ) > 0, {Intake Status}, FIND("Triage, ARB Approval Buisness Case FinRev Approval CIC Approval", @cell ) > 0)…
-
End of Month Formula
I am using this formula to look at the created date of a submittal and then generate the end of the month date based on when it was created: =DATE(YEAR(Created@row ), MONTH(Created@row ) + 1, 1) - 1 But if something is created on the last day of the month, it puts the end of the month date for the next month. So, for…
-
Copy parent row only
I have automation set up to copy rows marked as "key deliverables" in my project schedule into a separate, key deliverables status tracking log. Unfortunately, when a key deliverables row in the schedule is a parent row -- i.e., has subtasks under it -- the automation (rightfully) copies the parent row AND its child…
-
Looking for help with a formula that wont allow a selection if tow other fields have requirements
We are using Smartsheet to track system request as a PMO and Approval tracking. We have a field we select the Approver from to get this automated workflow to kick off however depending on the complexity it my require 1 or 2 UAT (User Access Testing) and want to ensure our users if one or both are required they cant select…
-
How can you view an AI generated chart or graph on the Mobile App?
I added a few AI generated apps to a Dashboard, and it worked great, but on the Mobile App, they all display as "Content Unavailable".