-
Hide the rows with error without blocking the calculation
Hi Guys, I have a scenario here. I need to refer another sheet and I have to skip the count when the cell have any error. How should I perform that in smartsheet. Can anyone help with this one? With Regard lepote Jo
-
Populating a Date field using formulas
Hi All, I have 2 known variables that I want to use to populate a Date field: We know the date that a Learner starts a course [Start_Date], and we know the cadence at which a report should be pulled afterward [Report_Cadence] (sometimes in weeks, sometimes in weeks + days). I am having trouble creating a formal that will…
-
Currency Symbols in SUM Formula
Hi I am using the SUM formula to total a column cost in my sheet summary. How do I get the £ symbol to show in the sheet summary field so, that when I pull it onto my dashboard it display as a currency figure rather than a random number? I know it's going to end up being something super simple! 🤔
-
Use OR in a formula
Hello. I am working on a formula and I have most of it complete. I have never used the OR function, but I think that is what I need to make this work correctly. Maybe it's just me, but I never really understand how to use it from just the Smartsheet examples. Here is my current formula: =COUNTIFS({WO Tickets…
-
Need to create a column that translates "End Date" Month to Quarter
Trying to create a column that tells me which quarter an item will be ready in the future. I can get the Month of the Date cell easy enough but can't figure out how to do a value range that works. This works =IF(MONTH([End Date]@row) <= 3, "Qtr 1", "Nope") and if the End Date is 1-3 it will say "Qtr 1" Is there any way to…
-
How to have a date formula based off another date formula?
Hello, My situation is I have a master list that has all my event IDs and event start dates. Every event has a separate "project plan" sheet based off a template. When you enter the Event ID on the project plan in [details]1, the event info, such as event start date, pulls from the master sheet using index match. Part of…
-
Some cells not populating with column formula
Hello all, I've got a column formula that automatically determines start date based on a different date. It appears though that some cells are not populating (see snapshot) and I wondered if anyone can advise why it might be? The Start-Up duration column has a column formula "=3" for 3 months and Start-Up start date should…
-
What formulas help join people, teams, AND roles (person may have >1 team and >1 role)?
Stephen Covey says begin with the end in mind. I want to create views of people by scrum team and role as well as by role and scrum team (end result mock-up pictures below). It would be easy if EACH PERSON was only on 1 TEAM and only had 1 ROLE, however, there are other scenarios such as: * 1 person on 2 or more TEAMS as 1…
-
Calculating percent of a percent in an =IF(AND formula
I'm trying to write a formula that says if one cell is less than 30% of another cell, then note the status as "At Risk." =IF(AND([Percent Complete]@row < [Timeline Progress]@row, [Percent Complete]@row = [Timeline Progress]@row * 0.3) / 1, "At Risk", "No Value")
-
Trying to use AverageIF.
Hello I am trying to make a formula that counts the average amount of time an active (open) issue takes, whilst segregating it by priority (low, medium, high). To count the total amount I used this formula: =SUMIFS({Time to fix}; {Solved}; 0; {Priority}; "LOW") However I want to make a new formula that counts the "time to…