-
New Early Adopter! - Kayla Crosby
Good Morning! Now that I have joined the Smartsheet Early Adopter program, I am very excited to connect with follow Early Adopters and talk formula's, dashboards, reports, and all other things Smartsheet. I am originally from the state of Connecticut up in the Northeast, but I now reside in Orlando, FL and work for Loews…
-
Email address (mailto: link) in Dashboards
Hi - Have there been any updates on being able to enter an email address (mailto: link) in Dashboards. I would like to add Key Contacts for the project in a Rich Text Widget and include links to emails for those contacts. I've tried but have not been successful. Any possible workarounds? Thanks, Jan P
-
Gantt Chart Alignment
I created a smartsheet using the Gantt chart template. For some reason the Gantt chart lines are slightly larger than the task lines. So when you're looking at a task and look right to see the gantt chart, it does not align with the proper task (Screenshot attached). This seems like Gantt 101 - The line has to match up…
-
Creating an At Risk Formula
Hello Community, I am trying to create a formula that will create a flag if the tasks are not marked as Completed in the check box column and the Due Date is within the next 3 days. I've made several attempts at using an IF/AND formula, but can't seem to get it to work properly. Any assistance you can provide would be…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Sorting Favorites
Hello - Is there a way to sort order of the items that appear in the Favorites section? I don't see the 'Pin to Top' option in Favorites and do not see a way to drag sheets to the top that I would like to appear first. Thanks!
-
Is there a size limitation for attachment files?
Is there a size limitation for attachment files? AND is there an overall limit for all attachments added to a Smartsheet? Thanks for your help! JanP
-
TimeStamp Formula Value
Hi, I would like to get a time/stamp value from a form entry onto to my master sheet , and have it reference the name of the person who made the entry. So for example, if I place an entry on the form, I need for my master sheet to match up my name and the time/stamp data and put it on my master sheet. Any suggestions,…
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
Auto fill a second column based on a drop down selection using a form
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one option from a dropdown of ~100 items. That value then populates into a sheet. (This seems…
