Pivot functionality of smartsheet
I have an existing excel which does the below job using pivot table.
For each project iCode, for each RFC if we have same PO and same line item then we are adding the cost. Hence for the first 2 lines we are adding. Again for line 4&5 we are adding the cost. And we are putting this into a different excel. Also we are filtering based on month.
Is it doable in smartsheet using pivot table?
Thanks for your reply