-
Scheduled Reports Not Generating
I have set up several recurring scheduled reports to be run this week, and NONE of them have run. I am using the "Send as Attachment", "PDF", "Schedule to send later or on a recurring basis", I set it up, then hit "Send", and the recurring event appears in the "Sent to" field with the circular arrow icon to its left, but…
-
Alert or notification based on date
I am searching for way to create an notification or a reminder based on a contract's expiration date. I have checked SmartSheet's help data but have found no way to make this happen. Can anyone assist me with how to do this .... all we want to be able to have, is when a contract is within 3 months of its expiration date, a…
-
add comment to individual cell, allow changes to comment name
Would be so helpful to be able to add a comment to an individual cell, not just to rows, like you can in Excel. Comments on rows get so messy and lumped together. Also need to be able to change the name/title of the comment or set it to reflect a different column other than the system column. Often for us, the project name…
-
Exporting Highlighted Rows to Excel
Ok, so I am not the one who has experienced this so bear with me as I explain it second hand. Users here have claimed that they used to be able to select a chunk of rows in a sheet and go up to the sheet options and export it to Excel and it would export only the highlighted rows. Now it exports the entire sheet. After…
-
Help with formula: COUNTIFS
I am trying to count the tasks not started yet so the column [% complete] is either blank or 0. I used this formula- COUNTIFS([% Complete]:[% Complete], "", [% Complete]:[% Complete], 0) but getting 0 as result whereas more than half of my tasks have not started yet. Any feedback highly appreciated. Thank you.
-
Sorting Issues
I'm still looking into this but has anyone had any issues with the sorting feature? We have one sheet that 17 people are constantly working in a day. (All Editors and 2 Admins if that makes any difference) This morning we SORTED several rows and HOURS later someone who had the sheet open, saved their data and INSTANTLY ALL…
-
COUNTIFS and with 2 different values in same column?
Hi there, I'm trying to create a formula to count when 2 different types of activity in a column ("Key Initiative" and "Initiative" have the value "Complete". I've been trying different ways to organize COUNTIFS to solve the problem, but I'm getting either "0" or #Unparse as a result. The most straightforward formula I've…
-
Filter based update requests
Hello dear Smartsheet staff, I noticed discussions about update requests, some concern single or multiple rows, others concern columns or the whole sheet. Could it be possible to implement FILTER-BASED update requests? I guess that would satisfy everybody's needs. Best,
-
Sharing Sheets to Multiple Workspaces
I was wondering if I could have a sheet be located in multiple workspaces simultaneously. For example If I wanted to have individual workspaces for each project I am working on, but also have separate workspaces that would allow me to see overviews for ALL projects, all pulling from the same sheets.
-
Line Break as Delimiter in JOIN(CHILDREN()) Formula
1. I want to aggregate text information from child cells and use a line break as delimiter. How can I do this? 2. In Addition it would be nice to have "Primary Column" as prefix before the respective contents. Example Values for Primary Columns for two rows: Child 1, Child2 Value for relevant text cell of child 1: - lorem…