-
New update has broken reports, cell drop down lists are gone
As of this morning, dropdown lists no longer work in any of our reports, only the main sheet. This is a major problem...any ideas what's going on? Logged out and logged back in several times, but to no avail.
-
Report - max rows 500?
Morning, Can a smartsheet report only accomodate 500 rows? Is there a solution for >500 rows? Thanks.
-
Search the current report?
I know there is a way to constrain a search to the "current sheet". Is there a way to constrain a search to the current *report*. Thanks, Stan
-
Multi Project Milestone Report
I have a series of projects that I need to report out the End Date for each of the milestones and I'd like to do that in a table. So here is what I have. I have 7 projects, each with 7 Milestones, each with 1 dates. I laid those out in a report as 3 separate columns - Project, Milestone, Date. So what I need a table with…
-
Row print
I can't find a discussion that covers this: I know there's a way to print a single row with columns in vertical view, with the option to include hidden columns, but is there a way to automatically exclude printing blank columns? I have columns that don't apply to all rows, so when printing there are blank lines. I could…
-
combining formula to round a sum
I'd like to know if I can combine the two following formulas in some way so that I only need one column: In the first below, I'm calculating the average number of minutes an editor spends on each page of a document. But, because I don't want to report the number with such precision, I have a second column with a formula to…
-
Template Sheet With a Deadline Column
Hi there everyone! I wanted to ask if there is a tamplate with deadline dates. Where we work we send tasks to our drafters with 3days of work, some times they can end the task on 5days. And we wanted to track the total of days we gave them to work with and the dates they used to work on that task. Can someone help with…
-
Highlight Changes Viewable on Ipad
Is it possible for an ipad user to see the highlights of when a cell changed?
-
Work around to formulas across sheets
I am working with 2x sheets - one a CRM, the other a job list. I would like to be able to flag on the Job list when a customer name is entered which is not already in the CRM. In Excel I could use a combination of ISERROR & MATCH to achieve this, however from what I can work out formulas across sheets is not possible on…
-
Date Formula to exclude weekends
Hi Friends, I need a formula that would result in a Date = Today + 1 day, but if Date is on a Saturday or Sunday, Date should be the following Monday. I also need the same for Date = Today + 3 days but the calculated Date should add 3 week days (Mon - Fri) and not be a Saterday or Sunday. Hope this make sense?
