I have a spreadsheet has data related to customers orders by accounts, status and dates. This spreadsheet feeds a roll up sheet that rolls up the information from the base spreadsheet. I then take tha…
Hello All! I am stuck trying to fix the automation of my RYG balls in Smartsheets! I need to add one more IF formula to be the formula below so that if a task has not yet been started, the ball will s…
Is there any way for font color changes via conditional formatting to be shown on the cards? I have a formula the changes the row's font color red when an end date field is in the past. Unfotunately I…
I'm collecting data on number of inspections conducted each day, and would like to calculate summaries for each week and month. I've figured out the month formula, but struggling with how to do this f…
Header Rows that group and/or describe the rows beneath them are very useful (especially in to-do lists) but they could be better in a couple of ways: 1. Allow users to designate rows as 'header rows'…
Hello, Can I get some guidance on how to properly use Parent/Children formulas for a Summary sheet that is fed by information from a reference sheet? I have several count ifs, and sum ifs all correspo…
I've created the following cross sheet CountIfs formula: =COUNTIFS({Hutto NA Status}, "Done", {Hutto NA Owner}, [Primary Column]15, {Hutto NA Date}, >TODAY(-7)) Each segment works perfectly on its own…
I'm hoping someone in the community can help me understand the business logic behind the way durations are calculated over weekends in Smartsheet. For context, my sheet has out-of-box settings for wor…
Hi I don't seem to be able to affix any text to =PARENT()? I want to have each of 6 child rows as: =PARENT().01 =PARENT().02 =PARENT().03 =PARENT().04 =PARENT().05 =PARENT().06 Any thoughts? Thanks Ch…
I am having issues with a formula that I try an use to count dates in a column that are less than the present day. With a modification the formula works just fine count the number of dates within the …