-
Vlookup
I am updating information on to a sheet when I contact our customers AP dept either by email or Phone. The info I update includes Invoice- date- AP response. I want to use this data to link to another sheet that I am using to track open invoices via Vlookup. When I populate the sheet I have been inserting rows on top so…
-
sharing permision
Hello, I work for a construction company and we use smartsheet to manage our project and we would like to share a folder without sharing the entire work space thank you :)
-
Calculate Difference Between Latest Entry and Previous Entry (Dates)
Hello! We are collecting weekly meter reading data (Meter Name, Reading Date, Actual Reading) via webform. I would like to create a calculation in a new column (within the sheet) that automatically calculates the weekly meter usage based on the meter name using current and previous entries by date. *For each Meter Name:…
-
Card View - Summary Rows & Totals
I'm supper excited about Card View but I can't figure out how to do the summary rows that are presented in the introduction video. Is this a setting? a series of formulas I need to do? do they happen automatically? thanks!! https://help.smartsheet.com/articles/2302238-using-card-view-to-visualize-your-project
-
what is the best way to get rid of #DIVIDE BY ZERO ?
what is the best way to get rid of the results of #DIVIDE BY ZERO. I have tried conditional formating, but that doesnt work. I am not having any insight with the if formulas. Thank you, Jef
-
IF statement formula needing help
I'm needing help completing a formula. The formula that is needed will look specific data in column "A" then specific data in column "B" with the result of these to coming from a different little grid. I've got the 1st (A & B) correct but can't seem to get the 3rd criteria to pull correctly. =IF(ISBLANK([column 1]3:[column…
-
Conditional Formatting Dates
I am trying to conditionally format dates that are in footers of grouped cells. The purpose is that I want to conditionally format dates in those cells that are 7, 14, and 30 days ago from today's date. The context is that these days are our initial contact date. If we go 7 days without contact (changing the date to the…
-
Ruler - alignment tool
We are only 6 months into our Smartsheet journey and thus often tinkering and creating new reports, it would be really handy to have a ruler at the top in order to align fields/columns in reports. I have marked where a ruler could sit with highlighter yellow below. Does anyone else recognise the need or have an alternative…
-
Looking for a way to send an automated email when using formula with TODAY()
Hi, I create a invoice register and would like to send out a reminder to manager for approval if there is no action by the manger after 2 days the invoice is raised. I set up a column called "Date pending for approval" with a formula "IF(OR([Approval Status]1 = "Submitted", ISBLANK([Approval Status]1)), TODAY() -…
-
Staff Widget Production Tracking
I'm trying to set up a Smartsheet to track the weekly work completed for each staff member and for the overall team. We do invoice processing, which has about 20 different invoice types. We currently have a Smartsheet set up that tracks invoice types in rows. The columns track workload, which includes invoices processed,…