Need help with IF + CONCATENATE formula

Platform discussions Special workflows & use cases
1

I have a tracking spreadsheet for projects and I’m trying to use Concatenate to specify the quarter and year when a project was completed, but leave cells blank if I haven’t entered a currency conversion based on an invoice posting date. The formula works to determine quarter and year for the completed items, but I keep getting a “One of the parameters is invalid” error on the blanks where a project is either active/quoted and has no posting date or associated currency conversion.

IF({USD/CAD - Posting Date}=“”,“”,CONCATENATE(“Q”,ROUNDUP(MONTH({Posting Date})/3,0)," ",YEAR({Posting Date})))

Any thoughts on how to fix this or be able to drive it from a date or status column instead?

2

Hi @MikiMau5 ,

As you use rather complex formulas, we can suggest trying our Smart Spreadsheet for monday app.

You’ll be able to import an existing board to the spreadsheet, then work with the data using all the Excel-like features (cell formulas, pivot tables, filtration, conditional formatting, etc.).

Hope it may simplify your work routine.

Best regards,
Katerina Kovriga, Stiltsoft

3 Likes