-
Checklist for Airbnb Cleaners
Hi all! I want to create a checklist for the cleaners who turn over my airbnb properties. I know how to create this checklist but there are a few specific things that I need it to do and can't figure out how. Any advice would be appreciated! 1) This checklist will need to be filled out each clean. That means there needs to…
-
Coverpage for Tempaltes
has anyone come up with a creative way to combine a template with a cover letter? So example - we use smartsheet to gather requirements, we want to deliver those requirements to our customer at the end of the project in a polished package. Right now, we use the export to PDF, and add a few notes in the provided comments…
-
Change Order of Sheets in Report
I have two sheets that show data from two different fiscal years: * [FY 2019] Course Development Tracker * [FY 2020] Course Development Tracker I added both of these to the Report Builder, but I want the data in [FY 2020] Course Development Tracker to appear above the data in [FY 2019] Course Development Tracker. I thought…
-
Report Not Updating
Hi everyone, I have a report that is not updating to show a newly added row. The origin sheet has been saved and refreshed. There is no criteria listed on the report that would affect the data to be shown. I'm new to Smartsheet user forms, so I'm not sure if my report is somehow affected by the form or reference sheet.…
-
COUNTIFS function
I have two columns that I am using, one is a checkbox column, the other is a date column. I want to know, of those that have a checkbox checked in one column, how many of them come after the date 07/01/2019 in the other column. Does anyone know the syntax for that? The column names. The checkbox column is "Approved", the…
-
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.
