-
Update Request Rules vs. Manual Update Requests
When I send out a manual update request it says my username via Smartsheets, and if someone hits reply, it goes to my email. If I set up an alert and action, it comes from Smartsheet Alerts & Actions, and if someone hits reply it goes to automation@smartsheet.com, and I never see this email. Is there a way to have the…
-
Bar Code Scanning for event registration
I am an event coordinator, and use Smartsheet mainly for managing my events. It is a great tool for keeping track of to do lists, timelines and event details. I even use it to collect RSVPs. What I'm wondering is if anyone here uses Smartshee's bar code scanner for event check-ins, or if anyone uses a third party…
-
Project Management, If then Statements
Hi, I was wondering about Project Management using Smartsheet. I am trying to create a project where there are many options or collateral pieces that key stakeholders can request from our marketing team based upon the amount of ROI projected and what they rank. E.G. Gold= anticipated $$$ Silver = $$ and Copper = $ If they…
-
Photo option in form
OK I am a newbie...I tried reading info on forms and options. I want my students to fill out info onto a form on my website. I would love to have them include a faceshot picture to be able to promote their progress in training...etc. A simple option that is already created when I filled out my profile is all that is needed…
-
DEPENDENCIES IN GANT CHART
How do I set up dependencies, working backwards from a mile stone / end goal.
-
Display a counter in a bar graph
Hi community, I'm making a bar graph which shows information in %, so each bar is the percentage of the information I want to show, but this '%' comes from a scalar number which I also want to display. Is there a way to do this? I attach an example.
-
Sights needs some improvements
Sights has been out for about six months now, but there are still no graphing widgets. When is SmartSheet planning on coming out with this functionality? Graphs are some of the main things people will look at when viewing a dashboard. Currently all we can do is list a whole bunch of raw numbers with little to no visuals. I…
-
Flag Red if under 100% or Past Due
Hello! Here is what I am trying to accomplish! In the column with the flags (highlighted yellow), I would like the flag to turn red when the Percent Complete Column (highlighted Green) is less than 100% OR if the Completion Date Column (Highlighted Blue) has a date past today's date. Please let me know if you can help with…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Need to show same event repeated on different separate dates on calendar view of my marketing plan t
For example. An email has to go out every Tuesday to all employees starting from say July until September. Or a teaser to be posted on social media on specific dates. July 2, July 10 July 14 and July 18. So basically I need to have multiple dates- in column cells be highlighted/colored (in the calendar view) for the same…
