-
Restrict field to numbers only
I apologize - I do think this should be a basic question that I could answer myself, but I cannot. I am new to Smartsheet so still learning. I see that you can set a field to Text/Number, but how do I restrict a field to only allow numbers to be entered? it's a field for a customer ID - that if someone attempts to type…
-
Dynamically Calculate Child Counts Based Upon Filters.
Hi All, How do I calculate the count of children in a parent row and have it dynamically change depending upon filtered results. I’ve tried COUNTIF and COUNT plus SUM CHILDREN and they all work showing the correct number of children before a filter is applied. When I apply a filter, the number of child rows reduce, based…
-
using external data in a form and sheet and for validation
Our company has an internal application. I would like to reference this application's data in a form and in a sheet: * When a user is submitting a form, it lets them select a value from a drop down that is populated from data in this external application * When a user is submitting a form, it lets them enter free-form text…
-
Task list option for each project
Hello everyone, I'm looking for a way to add projects (color project lines) in one sheet. In the solution center, there is a project category and in it there is a task list option for each project. In this option specifically, I wish I could put as many projects as I want. Do you know a way to get there ?
-
Resource Forecasting
Here's what I want to be able to do for resource management. Is there a workaround to accomplish this? * Assign individual resources (they are not licensed users) to a team\group. Assigning tasks to multiple individuals does not work for me. * Each individual has default work hours. E.g. 8 hrs. It can be modified if needed…
-
How to obtain access to WorkSheet Home without following 3-leg OAuth process
Hi. We are using SmartSheet to store multiple sheets that should be created by one person. This person will share one or more sheets in each of multiple workspaces. I am writing an application (in C#, hosted on AWS Lambda) that must access each Workspace, and Sheet, and read each Sheet. I am using the official SmartSheet…
-
Using Hierarchy Formulas & Conditional Formatting to Color Code Rows in a Sheet
I’m always interested to hear if someone else has figured out a better way to do something, so feedback is welcome and appreciated! (: Example Sheet: Hierarchy Formulas & Conditional Formatting I like to use colors to help guide me through a sheet and I have settled on a process that works for me. *See Picture* Minimum…
-
Favorite Smartsheet formatting tricks!
One of my favorite formatting tricks is the disapearing checkbox. This trick allows your header rows to look clean (without blank checkboxes). Check it out: https://www.smartsheet.com/blog/support-tip-formatting-tricks What's your favorite formatting trick?
-
Gantt zoom to current day (centered) on open?
Hello, Is there a setting to set the current day to be centered in the gantt view when I open my sheet? I always have to scroll over to the current day on long projects. Thanks, Phil
-
Need to transfer file ownership - Smartsheet won't let me!
Hello, I created a draft version of a workspace, now I need to transfer it to a licensed user and I get: "You have exceeded the maximum number of emails that your account can send" How can I get this fixed???? Thanks Karen