-
Will moving a sheet to a new workspace break associated reports?
We have a number of high-volume sheets used across multiple reports. Will moving these sheets to a new workspace break any associated reports - either in report functionality or user access? I'm thinking it's a "no", but would love a confirmation before I go ahead. A second question - what about renaming a workspace? Will…
-
is there a way to make children auto-calculate percent complete based on start/end date and the curr
I'm new to this program but not scheduling in general. Is there a way to get each child beneath a parent to calculate % complete automatically, based on the entered start/finish dates and the current date? I'm building construction schedules, and don't want to have to manually update huge amounts of child rows, especially…
-
Project Management Best Practice Ideas?
Good Morning Smartsheet Community! Does anyone have any best practices / suggestions they could share for multi-project management ideas? We are currently using a Report that pulls rows from the "Assigned To" column across all project sheets in specific workspaces; However, while it serves the purpose, it isnt visually…
-
if statement
Hello, I am trying to make an "if statement" but I got no luck. I don't know how to start, I tried with =IF(sqf1 > "32", "width1*hight1*5.5", "sqf1 < "32""width1*hight1*8.5") I know its looks bad :D Thank you
-
How to analyse/illustrate slippage of tasks in Smartsheet
Hi, I would like to get my sheets to highlight tasks which are overdue for completion in Smartsheet, and any subsequent tasks which may slip as a result. I imagine I will need to do a formula for this would be grateful for any advice on how to do this. Thanks
-
Tracking overall attendance to event
Building 2 different pages, one for general registration throughout the year, another to Track which companies have been to which events. The Registration is coming easy but how do I get it to fill in the Tracking sheet/report? So the Registration will track all the attendees for an event, of which there could be 1-10…
-
Reports - Hide the original sheets
We have master sheets that contain information on all products across 6 factories. We want to create a report for each factory that they then update relevant information for their products. This then allows all data to be viewed in the master sheet. The problem is that the report will show only the products that they have…
-
Notifications
Hi Guys, Im trying to set auto Notfication I have a Project sheet with Date type of coulmn called "Last Updated" I have another text Column Called balance Due I want to Create a notification if Balance due is higher then 0.00 Send Reminder 2 days after the date in the last updated Column and if not do able with smartsheets…
-
Search Function for Report Rows
Is there a way to allow the search function to search reports? I have used the search function from a report and search returns only rows from the controlling sheet. The report is used to give a user access to just the information they need to see/edit. The user getting sent to the originating sheet only makes it difficult…
-
Formula to get data from current week only by day of the week.
I have a worksheet with case information and who these cases are assigned to. I am trying to add columns that will total the cases from each day of the current week. ex. columns with a total count for mondays cases, tuesdays cases etc. thru friday. This worksheet has data for the whole month and all I need is the current…
