Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 27, 2022 06:17 PM
Hey,
I want to do a simple if statement to show TODAY for the date today. It works for a date field but not for a rollup date field.
IF({Date Rollup (from Stock)}=TODAY(),"TODAY","")
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 27, 2022 06:27 PM
Can you post some screen shots?
- the rollup tab of the rollup field, including the field being rolled up and the formula
- the formatting tab of the rollup field
- example values for the rollup field
- example values from the original field being rolled up
I also recommend when working with date fields to use formulas for comparison, instead of the equals operator. Look into the IS_SAME() function. It is documented in the Formula Field Reference.