Add text to formula column

Platform discussions Special workflows & use cases
1

Hello, Is it possible to add text to a formula column? For example My formula columns gives me the number of weeks a project will take, but I would like the column to say “4 weeks” instead of just “4”
Is this possible? I tried to do it (see below), but it didn’t work.

TEXT(ROUNDUP((days({Timeline#End},{Timeline#Start}))/7,0),"# Weeks")
2

@laura1

Try this:

IF({Timeline}, ROUNDUP((DAYS(IF({Timeline#End}, {Timeline#End}, "1-1-1"), IF({Timeline#Start},{Timeline#Start}, "1-1-1"))) / 7, 0) & " Weeks", "")

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Column Total in monday.com Formulas? YES!!!
Check out our monday apps, now in beta: The Monday Man Apps

1 Like
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.