Sign in to submit new ideas and vote

EDATE Function like Excel

ErikB

ErikB ✭✭

01/26/23 in Smartsheet Product Feedback & Ideas

Hi! Date math in Smartsheet requires fairly complex formulas for anything besides adding days. Can we add something like EDATE from Excel? This allows you to add a start date and a number of months to generate a new date.

Tags:

Formulas

5

5

5 votes

Idea Submitted · Last Updated 01/26/23

FAQs and Guidelines for posting Product Feedback Ideas
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…

Categories

Trending Ideas

Calendar App - colour & order consistency
I have a calendar in the calendar app with 2 column groups and multiple tiles. When i set and use filters the order of the columns flips randomly (the view does not remain constant). e.g. column 1 will show group A, Group B, Group C, but if i change the filter it will show C, B, A, or B, A, C (seemingly very random) - even…
Permit formulas in columns with the "Restrict" value toggle enabled
I have columns that are set to take certain types of data, and they contain formulas that fill the cells with values permissible within that data type. For instance, there's a field where a formula fills in one of several options based on a cell reference, or the user can manually select one of the options from a dropdown…
Workflows - Ordering/Sequencing
We need the ability to apply a sequence/order to Workflows. We have situations where two separate workflows have their condition met at the same time, and both of their outputs are targeting the same field (updating a status field, for example). We have no way of controlling which of these workflows take precedence (or…