I need a formula expert to help me write a formula that will calculate how many total WORKDAYS() have passed in the current year. I can’t figure out how to say ‘if year is current year, based on Today’s date, how many workdays have there been since t...
Can you give an example of when something that is overdue, becomes not overdue, then back into overdue again. Mapping this process may reveal a way to address the issue. :grinning:
real question not trolling, how does the URL field or formula field not serve your needs? I use URL fields and formula fields to dynamic generate clickable URLs constantly. I’m misunderstanding your needs I think. :slightly_smiling_face:
Try this:
IF({Type}="Furniture",SUM({Amount}*{Price 1}),IF({Type}="Fabric",SUM({Amount}*{Price 2})))
To work make a Single Select Field named Type with two options, Furniture and Fabric
Make a current or number filed called Amount
Make Two currency o...
