Formulas
Discussion List
- 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…
- 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).…
- Hi everyone, I'm pretty new to smartsheet so I may be asking your help for something that is quite easy to do :) I have an excel formula that I need to migrate to smartsheet to help me transform secon…
- I am trying to auto populate a column based on a selection I make in another column.
- I have this formula in a checkbox =IF(Date1 > [Stop Date]1, 0, 1) Stop date is a date field with =TODAY() - 15 and Date is any given date. The idea is to check items where Date is in the last two week…
- I'm trying to use the COUNTIF function to search a date column to count how many dates are within the next 180 days from today...but my formulas aren't working correctly. Failed Attempt 1: =COUNTIF([R…
- I have an estimated project Finish date of 8/9/16 in a column "Finish". this date is in row 6 and row 161. I have entered a row name TODAY and set the date to current date in the 'Finish" column row 4…
- I have a sheet that has checkboxes. I would like to be able to make a chart in the dashboard that shows percentage of how many checked out of total. I have a count for the checked boxes, but no total …
- I am trying to work on my sheet to get the % Completed to be automated. How can I go about doing this?
