-
Another parent-child condition format scenario
I've search Community and found several very excellent formulas that fall into the parent-child conditional format category; however, they rely on a checkbox type to function. In my scenario, the child row has a conditional format that when a date is within 15 days of target date, the row is highlighted. I'd like the…
-
Master Project Link Help
I am trying to create a master sheet with certain information from 20+ other sheets. Each row of the master sheet will be specific to one project with various dates that need to be tracked shown in each column. Is there a way to make each cell automatically know which project to pull information from without linking each…
-
Production Data Report
I am looking for help on setting up a dashboard of sorts to summarize monthly production data. What I have now in excel is that I can select a month from a drop down menu, and then the data fills into several tables I have made based on the selected month. Is there a way to have a similar setup within smart sheets? I…
-
Large amounts of free text
Hi, I am trying to use smart sheet to manage a research project. What I really want to have is a row that is the "aim of the project" with no task assigned to it. I also then want to list the team members involved, but do not want them all to be collaborators in the rue sense of the word. Is that possible? Thanks
-
Reports - Hide Data from Master Sheet
Hello, It is my understanding, that in order to share a report and allow for users to also make edits within the report, that they also have to have visibility of the master sheet that the report is pulling data from. Is it possible to share a report with users, while still allowing them to make edits, without allowing…
-
Web form and linking
Dear all, right now I am struggling a bit as I'd like to implement a web form that is forwarding information into a master table from which the new added row should be directly linked to further sheets to be evaluated and qualified. I had a look in former threads and tried the reporting function, but this won't let me…
-
Copying Links of a single cell to multiples on another sheet
Has anyone else had a problem copying a link to one reference cell to multiples on another sheet? We have the problem of trying to link a single reference number on a master sheet to a group of candidates on a second sheet. Functionality-wise I want a change in the master board to immediately update on the secondary list…
-
CEO interruptions causes delays
My CEO continually interjects his own agenda into the company's workflow. It's been a challenge for many years, and we all know that he won't change. So knowing that we, as a company, cannot tell him to stop, I would like to create some visual that will show how his interruptions cause delays in deliverables of other…
-
A simple functionality request: paste new user email address
When adding a new user (for assigning to a task), one can't currently paste the email address into the required field. It is tedious to have to type the email address and error prone. I believe that would be a simple functionality to add. Has Smartsheet thought about that? I am unlikely to be the first to notice.
-
Where did the export feature go for Published views
Prior to the major update that was just made if you had a Read Only Published link the user could download an Excel file of the sheet. Where did this feature go in the new update? We use this to convey a small segment of information to business partners without giving access to our whole data system.
