-
Formatting A Sheet
Hi all! I am back again with another Smartsheet question! This time I'm not certain if what I'm asking for is even possible. I was wondering if it would be possible to format 3 columns to make them smaller and more digestible. At the moment, I have a sheet that displays dates tasks have been completed, the week of that…
-
How to include a cell value name in my automation list
To setup automation, the trigger part works perfectly fine. However, the response is to change the cell value, but the cell name doesn't appear in any of the options.
-
Hierarchy and Child IDs
Good morning. I have to create 2 forms which will populate parent rows and child rows. I need the parent rows to have a unique quote ID (have this set up now), and child rows to either not have an ID, or have a specific ID that will tie back to the specific quote number. How do I do this?
-
Taking Average With Grouped Values
Hi all! I am very new to Smartsheet and am trying to come up with a solution regarding taking an average of matching column values. To explain in more detail, I have "Week Of" column and a "Days to Complete" column. I would like to take the average of the "Days to Complete", but only for corresponding weeks. Essentially,…
-
How to reverse the order in which a range is counted?
Hello, I have the following Smartsheet: In this Smartsheet, I'm building an asset booking system and, for the 'Asset Available During Your Booking Date Range?' column, it displays whether the particular asset is available for the date range inputted by the user. My formula is as follows: =IF(IF([Asset Booking Start…
-
When autofilling, prevent autonumbering
Hi, There are codes that I need to use that start with letters and have numbers after them. I want to be able to use the drag to autofill (in the lower right corner of the cell) the rows below it, with the same code. Every time I try, it autonumbers the rows below it which is very unhelpful. For example, my code is RP22…
-
How to indicate the Top5 from a smartsheet with Case-insensitive criteria?
Hello! This is my second question here. The community was incredibly helpful for the first one! :) - I want to pull the Top 5 Customers with more active projects from a project tracker (the user inputs project ID and from a data pool, the Customer Name and other info are pulled) to a dashboard chart. So far, I am using a…
-
Why can't I have a formula in %% complete when dependencies are enabled?
I just spent a very long time figuring out how to make the %% complete column auto populate based on the dates. I was proud of my work until I had to 'enable dependencies' so that I could have predecessors. Surely it cannot be that uncommon for people to need both. My investors get reports where the 100% complete column is…
-
HELP: Formula for Dashboard
Hello, I've currently built a form that allows people to Check-In and Check-Out, which then they'll have a drop-down and select their name. I've also built an automated dashboard which will indicate how many people are currently checked IN in each area. Some of our staff forget to Check-Out when leaving work. How can I…
-
Sheets Created from Pivots
Is there a way to tell if a sheet was created from a Pivot? Are there any properties within the sheet that would indicate how it was created? I am finding that with the transfer of ownership of Workspaces and Pivots, things aren't populating correctly. And is there any way within the Pivot app to see the destination sheets…
