-
How do I calculated Expected Completion %
Hi! My Smartsheet rep designed a formula for me but it's no longer working. I don't know what I changed to cause the error. I am trying to calculate if a project is ahead or behind schedule. Here is what I have that is returning the error #INVALISD DATA TYPE Assistance is very much appreciated.
-
IF COUNTIFS Formula for Multiple Status Circles
Hello, I currently have this formula: =IF(COUNTIFS(KPIs31:KPIs36, "Red") > 0, "Red", IF(COUNTIFS(KPIs31:KPIs36, "Yellow") > 0, "Yellow", "Green")) in the Parent row. This takes the underlying status circles (children) within the parent so if there's at least one Red, it results in Red in the parent cell. If there's at…
-
I am trying to count the number of rows in one column with reference to a value in another column
Hi All, I am trying to build a formula in 'summary sheet' data to refer two two columns. Count the number of rows in MCB Rational Column(if a value exists) only if the other column 'Count of current year' says 'true'. I am using formula - =COUNTIFS([MCB Rational]:[MCB Rational],@row, [Count for current year]:[Count for…
-
Clear Cell Workflow, not working with cross-sheet formula
Hello, I'm trying to clear the cells from a couple columns when a date is changed, but it is not working. The date has a formula that is currently pulling in data from another sheet. Could this be the reason why? I also tested a the clear cells workflow when a cell with a simple formula (not cross-sheet) is in it and it…
-
autopopulate cells in indented row
Hello, We track projects in indented rows from parent columns. I was wondering if there is the capability to automatically fill in certain columns in the indented rows from the parents. I know that you can add the information in manually using =parent(), but I was wondering if there was a way so taht every time I create an…
-
Sheet Summary Formula > COUNTIF for column using formula
Hello, I maintain a large document tracker. It has one "Pending" column that uses a massive formula (pasted below for reference) to search the tracker for missing information, and if it identifies any, the column is flagged. I'd like to create a summary formula to count the number of pending documents. I'm trying…
-
New to Smartsheet - Setting alerts once status has changed
Hi all, I hope you are all doing well. I have tried to incorporate Smartsheet into my daily workings and hope you may be able to help. Seemingly, Excel is far easier when setting rules, but with automation needed I decided to use Smartsheet. Currently, I have a project on hold sheet which records all projects that are…
-
COUNTIF for "Dropdown (Multi Delect)"
Hi all, I'm hoping you might be able to help me. I'm putting together a Benefits tracker for my organisation's project portfolio, which aims to identify and categorise the Non-financial benefits (NFBs) that our projects will seek to realise. One of the aims of this tracker is to be able to quantify how many projects are…
-
IF Formula for Upcoming Date
I am attempting to pull in the next upcoming date, based on a specific clients name. At first I was thinking I would have a reference sheet for each client and use a MIN(COLLECT formula to pull in the next upcoming payroll date, which worked. Example of formula that worked: =MIN(COLLECT({Due Date}, {Due Date}, @cell >…
-
How do I use OR function in a COUNTIFS?
Hello! I am currently trying to use a COUNTIFS function to see how many projects are in a specific phase of development, but I only want to count those projects which are under the "Iceland" or "Iceland Foods Ltd - Retail" account to get a total view of the account. This is currently the formula I have: =COUNTIFS({NPD…