-
Empty Reports
Hi I created a report and scheduled it to to be sent every week to a user to see his tasks for the week. I want to stop sending the report if the report is empty for a week because it doesn't make sense to send a report with no tasks to a user. Do you have any thoughts?
-
Removing Months Headline from Calendar View
Hi, I am trying to print calendars from my sheets without the month headline on the top. I find it to be very confusing as it will not only list the month I am printing, but instead lists the range of months for the first date on the calendar to the last. For example, if I want to print February, it will say at the top,…
-
How to calculate number of days overdue on a task
Hi, I am new to the community. I would like to create a status field that changes color based on number of days overdue. Is there a way to calculate the number of days overdue in smartsheet? Thanks in advance! Susanna
-
Create double entries without overwriting data
I have created a new smartsheet document (Simple Excel like doc) for my team members for data entries. We have noticed that if 2 of them are enteringdata on the same row and at the same time, instead of creating 2 entries, the system overwrites the original entry. Is there a way to stop this from happenning. This becomes a…
-
=SUMIFS, Please help..Formular works on a business collages sheet....
Hi Team, This formula works on a business collage sheet, he reffed me to smart sheet and has been helping me build my sheet. this returns #Incorrect Argument Set....whats missing =SUMIF([Value of Jobs]2:[Value of Jobs]60, Result2:Result60, 1, [Sold Date]2:[Sold Date]60, MONTH(@cell) = MONTH(TODAY(), SUMIF([Value of…
-
Nested IF's Based on Date and Additional Criteria
Hi All, I am trying to craft a formula that will help automate the pacing of tasks. I have four columns: Task Name (Text), Task Completed (Checkbox), Task Status (Green, Red, Yellow, Blue), and Task Due Date (Date). For Example. [Determine Target Audience] - [Checked] - [Green] - [1/24/2017] I am trying to automate "Task…
-
Sorting
I would like to sort rows by Status column. Currently I have to click on the dropdown below the column heading , click on sort then click on the way I want to sort. In Excel I can sort by clicking on a column heading if I set it up that way. Is there a way to sort automatically when the status changes, or click on a column…
-
Data connector cell version information
Howdy, We are looking at attempting to do timelapse analysis (velocity, etc) with the SmartSheets Data Connector through Tableau. There are instructions on how to connect to the table for your sheet data; however, I am unable to locate anything that details how to connect to the cell version information to do time lapse.…
-
Regarding Formulas
Hi , I am new to smart sheets and i a bit confused about how theese formulas work I have bank register which the classfication by charge is used by coulmn set up as a drop sown list with categories i am trying to do the monthly Totals By classfication for example Auto expenses payroll etc, i am trying to find out which…
-
Requiring comments based on Web Forms Answers
Was trying to use web forms for a basis of a survey. Ideally I would like to create a required comment field based on the answer of the drop down box. Is this possible?
