Formulas
Discussion List
- I'm a new smartsheet user. I'm curious if I'm able to make a sheet, that pulls data from 4 columns and puts the info into Calendar View either to be displayed onto google calendar or on smartsheet cal…
- 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 fo…
- 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…
- 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 stateme…
- 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 …
- 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 …
- 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 dif…
- 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…
- 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({Shee…
- 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 sur…
