-
How to fix #UNPARSEABLE for my nested IF formula
Here is my nested IF formula and I don't understand where the issue lies. I've created a new column called [Initiative Expense] for my formula. My [Initiative Type] column has multiple values for types of expenses and credits, but if the value is one of five expenses (listed in parenthesis in the formula), then I want the…
-
Formula to correctly assign a quarter (e.g. Oct-Dec) to a due date
Hello! I have a sheet that lists project milestones with a column for the milestone's due date and another column that I want to automatically assign the quarter that that due date falls in (Jan-Mar, Apr-Jun, Jul-Sep, Oct-Dec, and Q5 - which represents the "current" quarter but next year). Then there are projections…
-
Allow $ (absolute references) in Column Formulas
Allow a Cell formula to be changed to a Column Formula when an $ (absolute references) is specified in the formula.
-
IF Function to Add Quarter and Year
Hello, I am editing a smartsheet that tracks tasks. I have a column for the quarter that needs the year based off [End Date]@row for all tasks added after the calculated quarter. I am using the formula: =IF(ISDATE([End Date]1), IF(MONTH([End Date]1) <= 3, "Q1", IF(MONTH([End Date]1) <= 6, "Q2", IF(MONTH([End Date]1) <= 9,…
-
How to add specific currency symbol?
Hello, I am trying to automate a smartsheet and I have done everything to this point, and have run into a problem. I have a PDF that needs to have money in it and it could be in any currency. so it could be $10,000 or ¥10,000, etc. But it doesn't fill the PDF with the money symbol and only the amount. It also doesn't add…
-
Count children but only some of them
How should this formula look if I want to only count children that are 'Open'? ="Project stage name - " + COUNT(CHILDREN()) I am using on the parent row in a project risk register so I can collapse stages not reached to focus on the risks for the current stage. However, some of the risks in the current stage are now…
-
index match formula not returning what I intended it
Dear All, Could you please help me with this formula? =INDEX({Project Plan - Task name}, MATCH([Start Date]@row, {Project Plan Range 1}, 0)) I wanted to show TASK NAME (from project plan) on the RACI file. What the formula seems to be returning is the name of item in either the Parent or the Tollgate/Phase column. Thank…
-
SUMIFS with 9 criteria
I am trying to sum specific values based on a dropdown list in one column and display that sum in another column. I have an "Amount" column , a "Total Final OEP 0708 Cost Center Spent" column , and a "Cost Center" dropdown column. I want to sum CHILD rows in column "Amount" based on the drop down option that is selected.…
-
Free Float [Slack] Formula
Calculate the float (or slack) between the task and the next successor task. If there are multiple successors, then it will select the one with the closest start date. Free Float (FF): The amount of time that a schedule activity can be delayed without delaying the early start date of any immediately following schedule…
-
Formal to Count for Past Year
I'm stuck trying to get a look back count of requests in the past year. For some reason the formula is coming back with 39 instead of the actual 32. Any ideas? Any help to also exclude the current month would be great! =IFERROR(COUNTIFS({Legal Pending Requests Range 1}, IFERROR(MONTH(@cell), 0) <= MONTH(TODAY(-365)),…
