-
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".
-
I'm trying to create a tracking system using two sheets.
One sheet is the Gift Card Quantities has the number of existing gift cards in each dollar amount and the other is a tracker that allows the user to enter the gift card used, dollar amount, quantity of gift cards. What I want to do is if a $50 dollar gift card is used, then that number is subtracted from the existing…
-
Automation adding contacts to a sheet from another (not dropdown)
For each project, we have a 'team list' sheet that shows up on the project dashboard. The team list uses cell links from our master employee list, so by entering the name, it automatically shows their phone number, department, etc. In theory, it should be updated at project kickoff and periodically throughout. It never…
-
Is there a way to populate the successors names in a cell based on successors column?
Hi there, I am working with a sheet that includes a predecessors column. I have also created a successors column that lists the successors. I need to display the names of the dependent initiatives in another column. Currently, I am using the following formula, which works only when there is a single successor: Dependent…
-
Health column formula troubleshooting
I want my health column to show as gray for any complete item, green for anything with an end date more than 5 days out, yellow for anything due in 5 or less days, and red for anything past due. It's very close to working, but I cannot figure out why some of these lines are showing gray, when they should be green (such as…
-
Quarterly Results
I'm still fairly new to using Smarthseet formulas. Although the idea is simple enough, I've tried to use COUNTIFS, based on some examples I've found on here that looked similar, but cannot get it to do what I want. My end goal is to create a Smartsheet to display quarterly results that includes the Assigned PM and the…