-
Unrecognized System Contacts
I'm seeing behavior in a sheet that I'm not sure if this expected or not. I am a known contact in our corporate instance of Smartsheet. The screenshot displays content in a sheet column that is created by submission of a form. For this particular column, it's populated from an email address in the form field. Submitters of…
-
Automated emails
I would like the ability to send an automated email to a sheet assignee at a certain time with attachments linked on that line in the smartsheet. preferrably I would like to be able to create a user group instead of a single assignee so that the email can be sent to multiple people but at this time it cannot be automated…
-
Averages with Errors
Hello, I'm trying to take an average of a range of cells. Some of these cells have a #Divide By Zero error in them because the source sheet does not yet have applicable data. I have used an IFERROR statement to change these cells into "blank" cells, yet when I use the following formula: =AVERAGE([Avg. Functionality]1:[Avg.…
-
Milestone Tracking Report - Numerous projects
Hi all I'm trying to create a status report which would roll up project tasks and their progress into an easily view-able report and/or widget The data will be across multiple sheets and I'm trying to find a way to trigger both active, complete and in progress data sets so that I can target the relevant stages inside of…
-
Scrolling with a mouse wheel
This is a minor thing but trying to figure out how to scroll up and down in my sheets using the wheel on my mouse. This works in every other piece of software I use but in a Smartsheet I have to use the slider bar on the side to move up and down through a sheet.
-
Task Dependency Block View
Would be awesome to be able to see projects in a format like that used by Casual.pm. Gantt charts make it very easy to see how tasks lead to deadlines, and to identify critical paths, but they are not great at immediately showing how tasks depend on one another, nor the total number of processes in action at any given…
-
Podio and SmartSheet
Is there a way to push projects from SmartSheets to Podio?
-
RGY Status - Overall Roll up
Hello helpful Smartsheet-ers! I have several rows that are utilizing the RGY buttons for health. I am trying to roll these up to a general status based on the choices in the individual rows. Can anyone help with a single formula that would capture: Green if all elements (rows) are green Yellow if one or more elements are…
-
Lookup text or number in last cell
Hello, I know how to do it on Excel, but cant seem to get it to work on Smartsheet. I have sheet that gets updated by a form filled out by other people. I would like a formula that would get the last piece of information added to particular cells in this sheet (add to bottom row) and display this in an overview cell.…
-
Referencing a Column in Another Sheet
I am having trouble referencing a Column in another sheet through an IF formula I am trying to do. My current formulas is =IF({Sheet 1 Range 1} = 1, {Sheet 2 Range 2}). The first Column I am referencing is a Checkbox Column, and I only want it to return the value in Range 2 unless Range 1 is Checked. Whenever I do this…
