-
Past Due Date in Business Day Formula
Hi! I have a formula I have been trying to figure out. I'm getting stuck because I want to make sure that the duration does not include weekends or holidays (if possible) and there is a condition. Any help would be appreciated. I would like to know how many business days past due a project is from today, but only if…
-
Auto Populate Contact List on Shared Smartsheet
Hello- I am looking for a solution to populate a couple hundred contacts into a Contact List for a shared Smartsheet without adding each contact to the sheet's Contact List manually. Here is the context: I have a shared Smartsheet that my team uses for tracking projects. Each project is assigned to a member of my team (all…
-
API for linking MS Excel to SMARTSHEET
Greetings I am handling a number of projects and making Gantt charts to track their progress. The data for these charts are stored in MS Excel sheets on my local drive. It becomes cumbersome to manually import the dates and numbers to update the Gantt chart. I want to know, if there is way I can circumvent this problem. I…
-
Sheet Structured drop down list
I am looking for a solution to create a drop-down list with 125 options, which can be structured using categories to help users navigate and find the right option. Ideally, I would like to implement a filter at the top of the drop-down list, similar to the filtering options in Excel, where users can click on a category to…
-
locking row to the top
I have a sheet that gets filled with data from a form, is there a way I can lock the top row so when the form is filled the new row appears below the top row. I have the row locked but new rows from the form always appear above it. Just having the row appear at the bottom wont work for me as I want formulas in the top…
-
Populating a drop down from data in another sheet
Hello, I am in need of some assistance please! I am a developer and have been tasked with importing employee data into Smartsheet through the API. I have successfully built a C# service that pushes data into a sheet in smartsheet, my problem is they want to be able to auto populate a different secondary sheet (destination…
-
Wildcard workaround
Hi, Trying to get some counts for a report and have run into a bit of a road block. In excel, I would typical use a count formula and a wildcard. However, Smartsheet doesnt seem to have the capability. Below if my code: =COUNTIFS({Papers Range 2}, "*O'Malley*", {Papers Range 3}, "1 - Published") How would I edit this to…
-
Customizable view options in Smartsheet Card View
I think it would be useful to be able to customize the Card view in Smartsheet grids and reports to include additional view options, such as by date or other custom columns, instead of being limited to the default options like "status", "schedule health", or only being able to view by columns that are dropdowns or symbols.…
-
Merged: Collaborate without sheet view - Only attachments and comments
This discussion has been merged.
-
How To: Create Something Similar to Access Subforms
Good afternoon. I work at an enterprise level (10,000+ records per table/sheet), and am responsible for creating a Service Ticket system within Smartsheet. Previously, I accomplished this using Access' powerful Form/Subform datasheet systems with custom forms and conditional queries, but I am now required to use Smartsheet…
