Hi there ,
can anyone help me figure out a formula on this ? Need to add the "Contract term" in months, to the "Effective date", to get the "End date",
Here is a link to a thread with a solution:
10xViz.com
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi, I have a column formula that grab a link from reference sheet and I need this to be displayed before submitting the form. Example, column A is a drop down of items, each of these items can be downloaded from a shared link. So in column B I added a formula to grab the link from referenced table. However in the form I…
I'm trying to use a formula (below) that will: 1)If a deviation was Approved, it is past its End Date...if Past End Date return "Expired", if not return "Active" 2)If it was never Approved, return "Rejected"......no need to evaluate if it is past its End Date. My formula is returning Rejected only. =IF([Approval…
I've created a column formula that returns a value from another column if it has a value in it; if that other column does NOT have a value, it returns a blank cell. =IF(ISBLANK([Print Quantity (if known)]@row), "", [Print Quantity (if known)]@row) The formula works just fine, but I want to be able to type in a value to the…