-
SUMIFS of a value that falls between a rolling date range
Good Morning, I am struggling with the SUMIFS function. I have a sheet that contains job orders. The job orders have a planned start date. The jobs are also categorized by Job Type. I have the following columns: Job Type Planned Start JSH *job site hours* What I need is to calculate the sum of total JSH if the job falls…
-
Auto Downfill?
Is there a way for smartsheet to implement an auto-downfill function that allows users to input their desired formula into a column heading that makes every cell within that column (including cells added in the future) populate with said formula? This can help users decrease their time entering formulas and allow ease of…
-
How to Concatenate multiple cells into a single cell within a VLOOKUP formula?
I've created a VLOOKUP formula to pull in data from a source smartsheet, into a 'staging' smartsheet but, if more than one row match the criteria, only the first row entered in the source smartsheet get entered into the cell on the 'staging' smartsheet. For instance, I'm looking for entries on the source smartsheet that…
-
How to determine how close I am to linking limits
Hi all, Is there a reasonable way to know if I'm getting close to the cross sheet link limits? Thanks, Darrell
-
Report Features
Hi, may I know can I add any bar or pie chart and customize the design of the smart sheet report just like the widget in the dashboard? Thank you.
-
Creating a Purchase order spreadsheet
Wondering what template might be the best way to create and share a purchase order system for our construction projects. I want to add links, pictures, pricing quantities etc. Can anyone help with this
-
Activity Tracker
Hi, I have lots of sheets with different stakeholders who update these sheets, I want to check which row items have not been updated after their due date or Actual End date. How can I schedule report like that?
-
Building a Dashboard from a Report
Is this possible? I went to try and create a metrics sheet from the report but it doesn't show up. Building the report was supposed to group all of my similar items together, why can i not then build a metric sheet to create my Dash based upon that report?
-
Send Request for Approval Again
Hi: I have a column set up that an instructional designer changes as the status of a project changes, and I have another column that indicates the status of approval. When the ID changes the status of the development to "In Review", a trigger sends the Program Chair a request for approval. If approved, the ID can change…
-
SUM or COUNTIF across sheets
I have a Smartsheet for each fiscal year, and will continue to add new sheets for each FY. On a separate sheet, I want to find the sum of values that appears in all of the FY sheets. For example, if I want to sum the total amount an employee makes on my Summary Sheet, referencing data on multiple FY sheets, I know I can…
