- 为事件registratio条形码扫描n
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…
- Could I refer a cell as part of the sheet name in functions?
I have a column with different carriers such as "AT&T" and "Verizon". And in the following column is a complicated nested functions, and part of it is doing search depending on the carrier name. For example, for the row "AT&T", I want search in the sheet named "ABC AT&T". For "Verizon", I want to search in the sheet named…
