-
Is there a way to define "today's" health, based on today's date and corresponding "% completion" va
Hey everyone, I've got a set of data pulling in completion % by date, and want to give my team a quick snapshot of overall health of the project based on completion % for TODAY(). I have used the following formula, which works for giving RYG per day: =IF(AND(Date9 = TODAY(), Difference9 < 0.05), "Green", IF(AND(Date9 =…
-
Countifs formula error
within the same report as my list of projects I'm trying to return a count of projects that are due to start within the current week (day 0 - 7) from "today" then return a count of project for next week from (day 8 - 13) then week 3 (day 14 - 20). here's the formula I came up with but it's not working.…
-
f(x) & Edit Reference do not appear
The help documentation states the following about cell references: “You can edit the name, referenced cell range, and source sheet of the reference.” If using a long formula and selecting the cell containing the formula, the left-most portion of the formula is not visible on the display (i.e., f(x) = AND Edit Reference do…
-
Reporting Using Parent Child Relationships
Hello - I have created a report to display the current user's list of high level milestones. This list is supposed to display any milestone that is blank under parent child relationship. This ensures only high level tasks are displayed. Its seems to work fairly well, but I have encountered one issue. For one of my sheets…
-
Stock sheet automatic email when stock drops below an amount....
Hi everyone, We're putting together a stock sheet and we want to create notifications so that when a figure in a cell drops below a certain amount an email is automatically sent to the relevant people so they know to re-order. Can anyone help please? Many thanks!
-
Setting up automatic reminder system
Hello community, I have a tricky question here concerning how to send out a reminder automatically based on the following idea. I have a sheet which lists the status of certain rows. Each row has a column that indicates with Green/Yellow/Red/Gray dots (symbols) - these indicate if an item has been fixed, pending, still…
-
Help with formula (IF > AND > THEN)
Hi team, Could you kindly help me out with the formula syntax for the following scenario please: If the "Rag Status" column is 'Red', and the "Complete" checkbox is not checked, then the "Action Status" must change to 'Overdue'. Link to sheet is HERE.
-
Project Management, If then Statements
Hi, I was wondering about Project Management using Smartsheet. I am trying to create a project where there are many options or collateral pieces that key stakeholders can request from our marketing team based upon the amount of ROI projected and what they rank. E.G. Gold= anticipated $$$ Silver = $$ and Copper = $ If they…
-
IF/AND Formula with Dates
I get a #UNPARSEABLE error on his formula. [Permit Agency Approved] is a date only column [Permit Agency Approved (F)] is a date only column =IF(AND(ISBLANK([Permit Agency Approved]9)), [Permit Agency Approved (F)]9 < TODAY, "Review","None") What I would like to accomplish is, If the [Permit Agency Approved] column is…
-
BUG: #NO MATCH returned on X-Sheet Ref
I have two sheets, connected to each other via X-Sheet References. I tested this feature extensively when X-Sheet References came out http://ronin-global.com/2018/02/22/smartsheet-secure-your-sheets-with-x-sheet-references/ Today, I got this behavior On Main Sheet, I add a Row. I get a #NO MATCH on the return value. In a…
