-
Cannot convert to column formula to save my life...
I have two columns: Days Open and Turnaround, depending on "Status". I have tried so many ways to convert these to column formulas and Smartsheet will not let me. A lot of folks will be using this sheet so I'd rather not rely on everyone dragging down the formulas if I can help it. I've created a sheet with literally just…
-
Help with cross-sheet automation and formulas
I have 2 separate sheets to manage my team's assignments. One is a weekly assignments sheet that pulls from a partner request form and a daily assignment sheet where I manually assign tasks and priority level to each assignment. I want to make it so that when I assign Tier 1 or Tier 2 priority on the 2nd sheet, it…
-
Has Children Function
Hi, I am trying to create a formula that will output the average of the child rows IF and ONLY if a line has child rows. If a line doesn't have child rows, I would like it to output (for example) the number "0" if the status column, Status@row, is "To Do" and "100" if Status@row is "Complete". Please let me know if there…
-
Formula Help
I have been trying to work on a formula within smartsheet and only part of the formula is working and I have been using AI through smartsheet. I need help with tha last 2 parts of this formula to get the date value to populate in the cell. The N/A portion works. Formula Description is used in AI is this =IF the [Kit Type]…
-
Formula based of portfolio report
Hi, I would like to do a simple count and countif based of my portfolio report. But when I start the formula and want to link to the report, it is not available for selection. I am the admin/owner of the report. Is it just not possible to use a portfolio file for formulas?
-
How can you count someone assigned to a cell if there are multiple people assigned in the same cell
Im using a metrics sheet to show home many people have RYGB symbols. However, there are some rows that have more that one person assigned to the task and it will not count their symbol if this is the case. Is there a formula that can count even if there is more than one person in the "ball in court" column?
-
COUNTIFS formula with several criteria not feeding into metrics correctly
We are trying to map out our issues that have been reported each month, with various criteria, and how many have been closed each month. I can see the data in my report, but i cant get it to feed over into my metrics sheet This is the formula that I am using: =COUNTIFS({Amadeus: TC Known Issues & Limitations Mas Range 2},…
-
Taking 1 Criteria and counting how often another occurs when Criteria 1 is met
I am trying to take if Canada (on a separate Smartsheet) is found, and if Africa is found (on a separate Smartsheet), count up how often it occurs This is the formula that I am using but i think its counting Canada on top of Africa =COUNTIFS({Graphical Behavior Analysis: 1S Graphical Range 1}, HAS(@cell, "Canada")) +…
-
Harvey balls formula
I'm trying to denote row status using harvey balls of 4 colors - red, yellow, orange and grey. Red - Blocked or end date is past Yellow - Start date is past AND status is not In Progress Green - End date is in the future Gray - Not started This is my formula - =IF(Status@row = "Not Started", "Gray", IF(OR(Status@row =…
-
Use IF Statement with Contact field
I have a workflow being sent to a user. Now this user may decide to delegate the task to someone else (by forwarding the workflow). Can I add an If statement to my workflow to see if the name in the Certified By is the same name as the TDL Project Manager? If they are the same, I want the workflow to be sent to ONLY the…