-
Deleting Columns
I have a sheet (I"ll call it Sheet 2) that is populated with an automation of rows copying over from another sheet (I'll call this Sheet 1). I only want to see 5 of about 30 of the columns in Sheet 2. If I delete columns on Sheet 2, when a line copies over from Sheet 1, the next day, all of the columns reappear on Sheet 2.…
-
Cannot see sheets shared to me
I can no longer see all the sheets shared to me, even though I could see them all last week. I have requested access to them again and was granted 'edit' access and used them the same day. But the next day they have gone again. I have tried logging in with a different browser but still cannot see the sheets. Why is this…
-
Tasks with multiple start and completed stages before FINAL completion
Hello! I'm building a sheet to track multiple tasks. Each task (FILE) has different stages of completion (PROCESS/INTAKE, Research, Drafting, Reviewing and Finalizing). Each stage has an ASSIGNED TO contact and COMPLETED date. The Finalizing date will be the FINAL/END date. We want to track turnaround time per ASSIGNED TO…
-
What is the best way to create a form, where you want to capture info on multiple occasions?
We are creating a three part learning series for HCP's and want to use one form to capture information presented during each visit. Is it possible to use a logical sequence only shows once each visit is entered? (Ex. Date 1, xyz presentation, then Date 2 is available to populate to enter xyz presentation) Or would I need…
-
Need help with date reporting formula
I have 4 formulas in seperate cells that look at open and closed actions and does a count of how many there are for those months. The current formula for the current month:- =COUNTIFS({Date opened}, >=DATE(YEAR(TODAY()), MONTH(TODAY()), 1), {Date opened}, <DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1)) works fine and has done…
-
Resource Calendar - OOO
Hello Smartsheet Community, Is there a feature to create a calendar that would list when project resources are out of the office? I have an Excel document, but wondered if there is something available. Very helpful when looking at the months ahead for timeline.
-
DataMesh Note Section
Within DataMesh it would be really helpful to include an additional field to provide a description of what workspace/purpose etc. that the DataMesh config is applicable to. Currently I have ~50 configs for various workspaces. I have come up with a naming structure however I am limited to how much space I can use.
-
Resource Management: Regional Public Holidays
Official Public Holidays in Resource Management are not helpful when team members work across different states or countries. The ability to define Public Holidays based on team member location (automatically would be best) is needed. The Location of each team member is defined in their profile. Use this to update the…
-
iCal to Outlook - Filtered Calendar?
I have a sheet that collects information relevant to multiple people, think of these items as task assignments. I would like to have this integrated into each individual's Outlook calendar, but I want to filter it only to what pertains to them, is this possible? I understand it can't be done from a report. I also…
-
Conditional Logic in Form
We offer non-credit classes for older adults as part of our statewide program and our campus program. I have combined them into a single sheet with one form. The URL we share with potential presenters has a query string with a fragment that autofills a field in the form to indicate if its statewide or campus. This is great…