-
How do I return a date based off of a numerical value?
Hi Smartsheets Community, I have 12 columns that each represent one month and in those columns there are numbers (not dates). Every month I will enter that month's financial data. I want to write a formula that tells me which month was the last month to be updated and I want it to return that month's date (vs. a text value…
-
IF formula for Status of Child
Hi - I'm looking for a formula that will display "All tasks complete" in the Parent Status cell, if the Status of all Child tasks is set to "Complete" (and will display "Incomplete Tasks" if any Child tasks have any other status).
-
Utilizing IF to open different sheet upon condition
Hello everyone, I have been googling this for a while, and decided it would just be easier to sign up for the forums and post my question. What I am trying to do should be a simple IF function statement whereas if a dropdown list entry is hit in a cell, then the user is pointed to another sheet. e.g. Dropdown box 1 on…
-
Finding the latest date of certain tasks based of those tasks' attributes
Hello, I'm looking to find the latest end date for certain tasks based off of attributes in those tasks' rows. For example: If I want to find the latest date of tasks in cycle 1 of a release (but not cycle 2), and within that there are 5 different categories of tasks but I only want to know the latest end date of one of…
-
Formula
This is my current formula and it is working fine. =IF([New/Existing]2 = "New" = AND(Segment2 = "Broker"), 0.4, 0.6) I want to add that if New/Existing is BLANK - to not return anything. Not sure how I can modify this. Help?
-
Conditional formatting for all children?
Hi, we principally use smartsheets to generate Gantt charts for our various projects. Ideally we would like to set up conditional formatting (for example task-bar color) for all of the children of different parents. So for example, let's say "Phase 1" of a project is the parent, we would like an easy way to have the…
-
How do I create an IF formula with checkbox?
Hi there! I'm trying to create a formula using a checkbox and I'm really struggling. Using the parameters below, can anyone help me with the formula? Column 1 = Australian states/jurisdictions (SA, WA, etc) Column 2 = Complete column with checkbox PROBLEM: If Column 2 is checked in Row 1, I want Column 1 in Row 2 to…
-
COUNTIFS returning #INCORRECT ARGUMENT SET
Hi all - I cannot figure out what's going wrong here. I'm trying to count rows in another sheet ("Sheet A") where both the following are true: * Done = 0 * IsChild = 0 My formula is: * =COUNTIFS({Sheet A Range 2}, 0, {Sheet A Range 4}, 0) Now this works perfectly! So in a cell right below that one, I then try to count rows…
-
Automated Alert & Action Issues
Hello I am trying to solve an issue with a system I have set up for Automated Alerts & Actions. See screenshots below. As you can see by screenshot 3, I have created a trigger column based on date surpassed; once that date is surpassed the cell will change from N to Y. The idea ultimately is when it changes to Y it…
-
sumifs with 2 dates and a rolling 12 month forecast
Hi Community, I'm now thinking about this already too long, so maybe you can help me out? It's about controlling the total amount of guarantees active within the next 12 months (rolling forecast). Every guarantee has a value, a starting date and a termination date. Setting within 1 sheet: Column1 = Euro guaranteed…