-
Auto Number Primary Column
Of the various data types a new column can use, it is logical that the Primary Column can only be Text/Number or Auto Number. However, Auto Number is not an option as of now. I would like to request having Auto Number be an option for the Primary Column. There are many applications of intake or request sheets are used…
-
Copy & Paste Contact Cells between Sheets
Currently only able to copy and paste contact cells on a single sheet.
-
Automation: lock row if attachments are present
I'd like to be able to build an automation to lock a row if attachments are present. How can I make this happen?
-
Customize the one click down for Card View or Gantt View in Reports
When you double click into a card/ gantt line, would love the ability to only show a sub selection of whatever columns were picked in the report vs someone having access to all that's available from the original sheet. Currently when we create reports, we love the clean view of only a few data points in a card view or…
-
Can a milestone task be closed based on completion of an approval task?
In each of my parent group of tasks I have an approval task, followed by a milestone task. Both are important for reporting. Example: Task1: Manager approves ABC Webpage for publishing Task2: Milestone: ABC Webpage ready for publishing - Predecessor for Task2 is Task1. Problem: When Task1 is marked Complete, I want Task2…
-
Automate dashboard?
Dear SmartSheet Community, I hope this message finds you well. I'm reaching out to inquire about SmartSheet's capabilities for automating the creation of weekly and monthly reports. Our objective is to streamline our workflow by eliminating the need for manual report generation. We are particularly interested in:…
-
Best Practice for Capturing Project Info on PM project plan
My team is using the Project Management Office template set. I love the template set but I saw this Project Information section on a different project template and I like the idea. I added it to the Project Plan template in our PMO, but I can't figure out how to use it or if there's a better way to capture this…
-
Is there a way to pull info from a form submission and enter it into another form?
I have a form I am currently running, that whenever answered, needs to be reviewed by another person. I am currently using the approval workflow, and putting it in the email with a link to a form that the reviewer needs to fill out. Is it possible to take the info given from the previous form and put it in the next one so…
-
Data Over Time Report/Dashboard
Hello, What steps should I take in creating a dashboard that includes a graph displaying data over time? I would love to be able to click on each data point and a pop up of that data point displays information during that time period. Here is an example of something I would like to create in Smartsheets
-
Countif containing specific text
Hello! I am trying to count to see how often a specific word, in this case a person's name, appears in a range of text. I've looked over similar questions and have started a formula, but I end up with an #INVALID OPERATION error. My formula is =COUNTIF({January Range}, FIND("Cassie", @cell, > 0)) I've also tried…
