-
Issue with CountIFs function
Hi all i'm currently attempting to use a COUNTIF function to count with 3 conditions. However my output comes up with 0 when there are more than 0 items that meet the criteria. Can anyone assist to see if my formula is incorrect? =COUNTIFS({Type}, HAS({Type}, "Storyline"), {Current Maintenance Assignee}, "Earl Prentice",…
-
Any Smartsheet users from Chicago area?
Hello, My team is looking to connect with other Smartsheet users to share ideas on how we leverage Smartsheet to manage tasks and projects. Now that our department is growing, it is crucial that we refine our Smartsheet work space and how we organize our work in portfolio style for each team: operational tasks versus…
-
Task Health
I am having hard time to have a formula to obtain the health color for the task I have 3 columns: End Date, Circuit Quote% Status and Quote Health IF(AND( [Circuit Quote % Status]@row <=0.5, [End Date]@row <= Today (7)), “Red” IF(AND([Circuit Quote % Status]@row >=0.51 , [Circuit Quote % Status]@row<=0.95, [End Date]row,…
-
TASK % COMPLETE FORMULA
I created a column to be provide me the task (row) total % complete. The two columns below have a dropdown status that each represent a % complete The % for each status is below: =IF([2nd Circuit Status]@row = “N/A”, IF(OR([1st Circuit Status]@row = “Waiting to sign the contract”, [1st Circuit Status]@row = “Waiting for…
-
Total % Complete for 4 columns
I think this formula should be easy but I am terrible with formulas. There are 4 columns, when there is a date = 25%, if there is no date =0% and the final column that will show total % complete for the 4 columns: Formula I have is: =SUM([LAN MIGRATION COMPLETE2]@rowDATE([LAN Migration Ready Actual]@row, 0.25) +…
-
How to setup an "If" with dates involved?
Pretty new to the SS scene. I am looking for assistance/guidance on how to create a formula to check the current date, and compare it to another date in a different column and if the difference is greater than XXX days have it provide a symbol. I have tried googling and have only found a bunch of functions:…
-
Calculate the right average for the columns
I need the average collect to calculate the right total % complete for the columns Each column that has a date is = 100% If there is no date is = 0% but the formula still counts the 0% to give the total % average complete on "Quote % Complete" column. If there is "N/A" either in "1st Circuit Quote Status or 2nd Circuit…
-
Cell reference in a notification subject line
Good afternoon, I have a notification action set to send a notification note any time a specific cell is updated. Currently the action seems to allow me to set a standard subject line response something like "Changes to SHEETNAME: Notification". What I would like to do is have the subject line pick up a specific cell so…
-
Can I automatically adjust predecessor dates by changing the dependent date?
I'm looking to create a dynamic project schedule with the functionality described below and would appreciate any help from the Community! Our dependent task end date changes rather frequently based on shifting priorities. I would like to change the final dependent end date (in this example, 'swim') to 3 days later (9/10)…
-
Can a one to many relationship be created in Smartsheets?
For example I have sheet A that has my master list and all components within a "Kit". On sheet B I have multiple kits and would like to reference all the included components. I get that you can link cell to another just like and spreadsheet, but is there a way to link the value?
