If Term_Effective_Date = 12/07/15 and Terms_In_Year = 3 Years. What is the formula to calcuate the New Date? I need to add 3 years to 12/07/15. =DATE(YEAR(Term_Effecitve_Date2) + [Terms_In _Year]2, MONTH(Term_Effecitve_Date2), DAY(Term_Effecitve_Date2)) I am getting #NUMBER EXPECTED as an error. Thank you for helping!
Dear all, I have been trying to find the explanation but not yet found the right one. I am really new to smartsheet but reallly love to use it as it is such a powerful and smartlike it's name. I would be very delight if someone could advise me know or is there is any possibillity to generate or making a patient booking…
I want to be able to show more than the 20-25 characters limited in the display of a calendar entry. e.g., I need to be able to show an "Issue No. (10 characters) + an Impact" which can be a list of multiple things. I would not mind if it wraps around into a second row as long as it displays all the information needed by…
I'm quite new to Smartsheet, and am really struggling with printing Gantt sheets. I have a simple project with 27 tasks, running for 6 month duration. But I can't find a way of printing the gantt without the task names being truncated (the labels that are in the Gantt part of the print itself. I have tried removing the…
My company is a private emergency response service. We were very excited when Smartsheet Labs came along and presented us with the ability to map our clients adresses. However this feature turned out less than great due to it using Bing rather than google maps. Adresses that should be easy to locate simply wont map on…
On my Entresto PPEP 2016 Sheet-- When I expand line 46, everything beneath it is lost. How do I fix this?? Thanks!
Hello - I've setup a webform for users to enter information about potential participants in a program. I want the form to automatically capture the date when the form is completed. I had initially set it up where I established a date field on the form but hid it from users. I thought by selecting 'Today' from the drop-down…
I'm not sure if this is a known or new issue, but I just discovered it today, and it's not cool. While importing a spreadsheet that has 17 columns and 350 rows, I found that the file I imported into SmartSheet was not like the original. I identified two problems: Starting with the worst - if the first cell in a line is…
We are undertaking major project across teams and areas and looking for a way to create a dashboard type display with ability to add spcific details. Basic requirements include. 1. We have 16 different workstreams grouped by column (overall status, staffing, planning, security, rerporting etc.). There are about 30 modules…
Is there dashboard view for all my projects? Something that launches as Home Page?
