- Email Notification template
When I setup an email notification everything works fine. However, as an email marketing specialist it pains me to send out the data in such a standard (boring) template. Is there a way to edit the look of the emails that are generated through Smartsheets? This would be a huge benefit to helping sell this software to my…
- Prefill dates in forms
Is it possible to prefill dates in forms? I am looking to fill the following in my forms: -todays date -4 business days in future based on todays date -Tomorrows date if submission is after 3pm
- IF () formula, Change Status Dependate on Date
I would like to build a formula so that status will change to "Red" and type will change to "Renew" when date is past "Expire Date". I've applied the two formulas separately at the top of each corresponding column. But so far it just changes it to Red or Renewed automatically, without the date dependency. Can I make this…
- Overriding Non-Working Days
Most of our projects include M-F working dates, however at the end of each project there is often a conference or event which may take place over a weekend or other non-working day. I'd love to be able to override and enter tasks on weekends for these instances without turning the entire project into a 7-day work week…
- Can't access any sheets when they're shared with me
Hi, whenever my boss tries to add me as a viewer to sheets we use to keep track of clients I never receive an email telling me the sheet was shared to me, and the sheet never shows up in my "shared to me" tab. I can't figure out why this is happening. On her end, it says that she shared it with me and i'm listed as a…
- Forms- Multiple guests contact informatio
Hello, We are using a form to RSVP to company events, for these events we have our team members inviting guests. The form is sent out by email to our team members and asks to provide their guest count, then we ask them to add their guest's contact info (name, company, email and phone number). The problem we have ran into,…
- List totals
I have a sheet that lists all of our clients by project. For reporting, i'd like to see a final report or dashboard widget that lists the clients name in order of most mentions within the original list. For example: List A Joe Doe Freddy Mercury Alice Chains Eddie Money Joe Doe Eddie Money Joe Doe Report: Joe Doe - 3 Eddie…
- Enhancement request - smarter autofill for dropdown menus
In a column using a dropdown list of options, it would be great if autofill was smarter - specifically, if it would suggest options based on any word in the list of options, not just the first word. For example: Typing "West" should bring up options like "Broadway Street West" or "Northwest Broadway" not just "West…
- 在另一个文本在一列显示日期.
I am moving a complex (static) spreadsheet to Smartsheet! One of the key drivers ensures that we show the date and the fact that it is NPI. In the Excel spreadsheet we have numerous columns (about 11 years but moving forward it will not be that big) showing Month/Year * When you enter NPI in one of the columns, then the…
- Comments column on web form
I am looking to create a webform that has the comments section. Now from what I have read thus far, it seems impossible to do. That if you want a free flow text field, you need a new column and have it as such: comments. However, some comments can be extensive. And if you wrap teh text, teh smartsheet becomes out of whack.…
