Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Start / finish Dates
I need to show the proposed start/end dates in the program to my client. He also wants to see actual start/finish dates. Is it possible to do this?
Dis-aggregate SS start and end dates in exported Excel
Hello, I am trying to see if any of the Excel wizards here can help me with a script or other macro that will disaggregate my SS exported project sheet data that contains start and end date columns (along with the usual duration column) information into individual rows for each day/date that is bounded by the SS start and…
Help with Date function please:
20th of the month..... 01/01/17 returns 20/01/17 .....need 20/02/17 31/01/17 returns 20/03/17.....need 20/02/17 #Invalid Data Type if Invoiced date empty (Where dose IFERROR go) DATE(YEAR([Invoiced Date]2), MONTH([Invoiced Date]2 + 30), 20)
Keyboard shortcut for Wrap Cell
Could you please create a keyboard shortcut for ‘Wrap’ text? 1) select: cell(s), columns(s), row(s) 2) keyboard shortcut >> wraps/unwraps selection Thank you.
Visual misalignment of highlighted row
Does anyone know how to get rid of the visual misalignment of a highlighted row on the screen. I am usually using Smartsheet on Safari. I tried to attach a screen shot of the issue.
sending comments to users emails
I'd like to have all "comments" between users be cc'd to the users gmail accounts. How do I go about that?
Combine tasks from different sheets into a single calendar view
How do I combine tasks from different sheets into a single calendar view? I have my sheets broken out by niche within my firm. I'm the marketing director of a CPA firm with oversight of marketing many niches; I'd like to see all daily responsibilities in a single calendar view. Is that possible? Thanks. Joe
Nested If using Date
Hi all, I have looked through the discussions and cannot find the answer, if it is a previously answered question, my apologies. I have three columns relevant to the question: Due Date Status Completed Date Status has conditional formatting, red, yellow and green corresponding to Awaiting resolution, overdue and completed,…
Smartsheet Community Sort Filter Question
I believe that the sort by "Recent" filter on the Community Home page only shows the most recent Discussions posted. It is possible to implement a sort that filters by the most recent dated comments to any discussion. You have this option when when you select a search TAG. It then gives you the options to sort by…
=DATE(YEAR([Invoiced Date]2), MONTH([Invoiced Date]2 + 30), 20)
Wanting the formula to return 20th of the next month when a invoice date is entered. 01/01/17 returns 20/01/17 or 31/01/17 returns 20/03/17. I need January sales to return 20/02/17 etc Where do i put the ERROR formula so it dosent return #Invaled Date Type ? =DATE(YEAR([Invoiced Date]2), MONTH([Invoiced Date]2 + 30), 20)
