-
Chart Columns
Notice in the attached picture that I have a chart that shows how much reimbursement a specific client received last year and as of the current date the client has received almost half of that. The issue is that the FY1718 (Red) column appears too small for the actual result. Visually, shouldn't it be about half the height…
-
Filter "is one of" drop down lists
Is there a way to clean up the drop down list on "is one of" filters? They still contain items that have been totally deleted from the column being filtered. This is very confusing to users. Thanks
-
Tasks automation
Is there any way to automize a process to transfer tasks from email account (on Mac) to Smart Sheet ?
-
time sheets form
I want to create a form that I can e mail the link to my employees on site weekly to collect hours. Ideally include Employee Name Start Date of week Day Site from a drop down list Hours at site Options two sites per day. Note at bottom to advise on holiday , illness Thanks in advance Grant
-
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…
