-
Visual budget management
Hello, I'm working on a total overview of projects in a sheet, using different columns with start and end dates and with budget reserved en budget spend. The thing is that I would like to compare the budget reserved with the budget spend. So that when the budget spend is higher then the budget reserved it changes color. I…
-
Smartsheet Customer Story Program
Hello Community! I manage the Customer Story Program here at Smartsheet, and currently we are looking for the next great story to share. There are many ways to share your story, and just as many benefits to participation. Sharing your story can document your success, grow your brand and advance your career. Learn more at…
-
Google Calendar
With the Google calendar refresh coming out on the 28th does anyone know if we will have to re-publish our smartsheet calendars to Google?
-
Drag fill across colomns
I have a sheet with 180 columns, each with a "add sum" *=sum([column name]:[column name]*. I am trying to "drag fill" the add sum across all 180 columns - but the formula does not adjust to the [column name]...any other way of doing this than typing the formula for each column? TY
-
Return "pending" if project lands between two dates
Hello, hoping for some help from the Smartsheet experts. I am looking to return "in progress" if a project lands between a project start date and project finish date. My start date, finish date and status are in 3 columns, side by side. Looking to automate the status column, to reflect in progress, when falling between 2…
-
Linking from a sheet that's reached the 5000 row limit
Hello Folks, I’m relatively new to smartsheets (3 months) but I’m diving right in creating sheets for a medium size construction firm. My recent project is a daily time reporting sheet for approximately 100 field employees. My sheet is up and running and is being rolled out to a limited number of supervisors during the…
-
Outlook Add-in
I'm wondering if there is a way to show more columns within Outlook when adding things to smartsheet via the smartsheet plugin, or if there is just a better way in general to accomplish what I'm trying to do. For example, if I receive an email confirmation for something and want to add it to the Task it is associated with,…
-
Finding a formula
I have a formula counting the last 8 numbers in a row. I have hovered over the cell and can't find the formula to copy it to another line what am I doing wrong?
-
keeping all responses from monthly update requests
I need to get some data from a partner every month. I have set up an update request to be automatically sent for that time frame, but I'm wondering ...does it add another row every time they respond to the update request? Or, when they respond to the automated request, does it overrun what was they had previously submitted…
-
DataMesh not finding cell links
I am having issues with DataMesh, as it is unable to look up the values between the sheets. I checked some of them manually, and the numbers exist on the target sheet. I also tried to export into Excel and test this formula. Excel required a re-format of the numbers (text to number format) before it was able to…