-
Wanting to pull "today's data from a column
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 that data to feed a dashboard. I need a formula I can put into the roll up sheet that pulls all the orders that are scheduled…
-
Help! Trying to edit the automation of RYG balls!
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 show up as gray. You can see from the screenshot below that all the other balls are working except when the task has yet to…
-
Counting summary data by week and month
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 for each week. I think I need to create a formula that specifies the date range for each week (though if this could be more…
-
Parent/Children Formulas with Date Ranges
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 corresponding to the month and the year. The parents and children will all have the same metrics and hierarchy for multiple…
-
Count Ifs giving error
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 but when I combine them, I keep getting an #INCORRECTARGUMENT error. I'm not sure what the issue is. Appreciate anyone's…
-
Date Logic - Weekends versus duration
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 working days and hours - Sat and Sun are non-working days, M-F are 8-hour durations. Looking at the attached example, I think…
-
Affixing content to '=PARENT()xx'
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 Cheers Richard
-
Countifs Issues with Date Columns
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 next 30 days. Both columns have conditional formatting associated with them, but the one giving me heartburn has the date…
-
Help with Countif Function Referecing 2 Columns on a different Sheet
I want to be able to see the count of Projects that are assigned to a specific person in one column and have a status of complete in another column. Not sure what I'm doing wrong? =COUNTIF({Master Task & Project List Range 1}, "Crystal Oliver", {Master Task & Project List Range 2}, "Complete") Am receiving "Incorrect…
-
How to combined VLOOKUP and SUMIFS
Hi everyone, I encounter one issue creating formula and linking between two different sheets. I don't know which formula to use but let me share with you what I have done and if you all have a solution to my problem, that would be great. I'm working on a financing sheet, it will be a lot about proposed cost, final cost,…
