-
Sumif WTheck?
Hello - I am trying to draft a formula to sum the column 9 but only when column 3 is "John Smith" and when column 11 is not equal to "complete." I got this far, but can't figure this out: =SUMIF([Column9]:[Column9],Column3; column3, @cell="John Smith")
-
Any experience with Aha! ?
Hi everyone! Our internal idea requests and other details live in Aha!. I'm beginning to look into exporting this data into specific Smartsheets. I am able to export from Aha! via Excel and then can utilize those files to import into Smartsheet. Does anyone have any experience with this or any tips for working between…
-
Enhancing Workflow Management on Consulting Projects
Hello! I need some help enhancing how we track our current projects in Smartsheet. I work for an engineering consulting firm. We have been using Smartsheet over the last 9 months to track tasks and manage workflow. The majority of our projects are labor-only. Due to the nature of our work with public agencies and…
-
Project Dashboard Generator
I am trying to develop a dashboard generator so that I don't have to recreate every report I use in our dashboards each time we have a new project. I would like to be able to select the project number in one location and have all the reports reference that project number to pull data from their respective sources, then…
-
linked cells
I am trying to find an answer prior to initiating a link. My Smart Sheet changes frequently and sometimes daily or hourly. Rows in the Smart Sheet are determining the order in which the projects will be drilled. The schedule will then change and the rows will be reordered to depict a new "drill date". Here is my question.…
-
Weekly Update Text Column
Hi Community— Need some advice. My team uses an Excel spreadsheet to track account updates. Weekly we add a column to the right and the team inputs a paragraph of text. So the existing Excel sheet is up to column "AH" since we are at calendar week W42. So next week ... "AI" and so on. The previous week's column is then…
-
Formula with checkbox
Hi everyone, I need help for a formula. I have created an ESTIMATE sheet for my projects, but sometimes clients decide that they no longer wan't some items to be included in the estimated. Instead of putting a 0 into my quantities, because I would lose the quantities number and maybe he would change is mind and decided to…
-
Multiple Projects - Resource Overview
Hi, we are using Smartsheet for managing our Sales Pipeline. As soon as a project is ordered, we are using the same line to gather project information related to execution. I would like to add a Gantt Chart to each lien (via Hyperlink to another Smartsheet) in one cell with resources. Question: I would like to see a…
-
Tracking Data / Shared Sheet
Hi! I'm really enjoying Smartsheet and glad we decided to go down the path of subscribing. While I was getting certified I found so many neat features and my mind just filled with all the things I could probably use various aspects of Smartsheet to accomplish. I ran into a limitation in my own scope that I'm sure…
-
how to receive excel file notification for the newest update in smartsheet ?
Hello, for the current smartsheet, for each new/update records in smartsheet: we receive an email notification for these updates. that is great.., however, in stead of receiving an email with all the new/update records on that email. are we able the send all the update/new records as an attachment - (excel format) via that…