-
Conditional formatting font color in Card View
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 can't see these changes in card view, only in grid. Thanks for the help!
-
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…
-
Smart Header Rows - Feature request
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' that are exempt from conditional-formatting, auto numbering and date-created fields, etc. 2. Allow a line's postion…
-
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,…