-
Hidden Columns in Reports - edit, print, send dialogues
Hi. i have built some reports off a large sheet where i have chosen to show only select columns related to the function of the report. I have also hidden some columns within the report. Yet when i use the Edit, Print, or Send dialogue boxes, all the columns from the main sheet are shown. Including the columns hidden in the…
-
Multiple users and automated backups
If multiple users have access to the same sheets, what impact does that have on automated backups? It would not be desirable to have more than one person backing up a single smart sheet.
-
Auto populate data and allow customers to update
Hi! I work for a membership based trade association and I'm trying to build a form that would allow me to share profile information on file with our customers (member companies) and then allow them to update outdated information. For example, I would auto populate contact information, # of employees, etc. and they would…
-
Record a Date automation keeps updating to today's date.
I am using the "Record a Date" function to identify an Approval Date when the status of a request changes to "Approved." The automation does record the date once the status is changed. However, once the date is recorded, the automation continually updates the date to the current date. For example: If a request was approved…
-
Columns do not line up if hidden if referencing 'in' from another sheet
Hello! I am referencing a single row of pertinent information into "Sheet #A, Master" from multiple other sheets "Content Sheet #b"; "Content Sheet #c"; "Content Sheet #d"; and so on. That works, but when I first build the link ALL of the columns in "Sheet #A, Master" need to be unhidden first. This is definitely a rich…
-
Published Sheets : Column Names Not Displaying For Certain Embedded Sheets
Good afternoon Community :) I have question concerning sheets that I have embedded on my intranet page. I use (and publish) different sheets to my company's intranet page, and for some reason only one of the sheets reflect the column names. What is odd about this is that the sheet that shows the column name is the exact…
-
Workflow automation - update requests
Hi, I need help. I have a workflow to send an automatic update request when a deadline is achived. The workflow is working perfect but I would like to send line by line and not all lines in same request. Anyone can help me to solve this? In addition i would like also to send an automatic e-mail when the first request is…
-
hierarchy numbering in sheet
Hi Team, Can someone help me how to get hierarchy numbering in sheet for example Project Plan 1.1.1 Resource of Project Plan 1.1.2 Conclusion of Project plan
-
I want to update a cell if any of the cells in a certain range of cells equals a certain text.
If ANY cells in Status3- Status7 = In Progress then I want Status2 to equal "In Progress, If ALL cells in Status3-Status7 = Complete then I want status2 to equal "Complete" @Paul Newcome @Andrée Starå