Forum Discussion
happy2belisac
Oct 13, 2021Copper Contributor
If Function = Add cell totals when criteria is met
I am using the IF function in Smartsheet, format is just a bit different, example below: I reference 4 "Date" columns: Ship Month, Deposit Month, Install Month, Other Month - if the criteria is m...
Riny_van_Eekelen
Oct 13, 2021Platinum Contributor
happy2belisac I believe you can use SUMIF, demonstrated in the example attached. It may or may not resemble your actual situation, but hopefully it will put you into the right direction. If not, better to upload a file that does reflect the actual table you are working with.