-
First time at ENGAGE 2022 and loving it!
This is my second here at #Engage2022 in Seattle, WA. and I feel amazing! What an wonderful experience to be attending to. I really happy to be surrounded by a diverse and enthusiastic group of peers, this is a great example of how in-person events were something that we were all missing. Sharing insights, knowledge,…
-
TOTAL% COLUMN
-
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…
