Support
Discussion List
-
Level a resource in a Sheet?In Using SmartsheetI've imported a project into a project sheet and now would like to level the resources that are overallocated so the schedule adjusts to show the actual schedule if I use these resources. Is there a way to do this? Thanks in advance, Sue
-
Why i am getting one combined email when adding multiple entries in a formIn Using SmartsheetHi Friends Hope you are doing good and staying safe! I am using Automation>Trigger>Alert someone feature to get email notification when user submits the form. I want to get individual email for each entry, however if user submits th…
-
Find the row with the earliest Created (Entered) date that matches certain criteriaIn Formulas and FunctionsThis one was a challenge. I thought I had it solved, but an erroneous value showed up, necessitating taking the formula back to the drawing board. The requirement: Show me the oldest Bill of Lading number that does not have a status of &…Answered - Pending Review 217 views 4 comments 1 point Most recent by Prime George Formulas and Functions
-
3 condition formula- HelpIn Formulas and FunctionsNeed help with a formula, 3 conditions- 1) Recognize first 3 digits of "ticket number" (EX: "LEG", "ONB", "REV") 2) Recognize when a task is past due 3) Status not "Complete" or "Not A…
-
Delete and Lock rowIn API & DevelopersDear All I would like to know. Is it possible, if I want my team can edit the row but they can't delete it?
-
Mark Duplicate valueIn Formulas and FunctionsHello team can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value thanks in advance oded
-
Multiply cell by 2 if checkbox is checkedIn Formulas and FunctionsHey Smartsheet users! I've read through a lot of check and IF formulas and haven't been able to find my answer so here is the situation. This is for a mileage reimbursement form. I have a column titled "Mileage" and another colum…
-
Can I combine multiple rows into one row on a Gantt Chart?In Using SmartsheetDear all, I want to aggregate multiple project schedules into a master schedule. When copying the milestones from various projects into a single sheet, my overall Gantt Chart displays an event as a row, and each project occupies many rows.…
-
Need help with formula to automatically fill in Contact List from another columnIn Formulas and FunctionsHello, I have the following columns and sheets and I just cannot seem to figure out how to do what I need. Sheet 1 (Main Sheet) Staff Listing (value is Text Full Name coming in from outside source) All Staff (Contact List selector (assigne…
-
Count Number of Cells that Contain Certain Text?In Formulas and FunctionsHello, I am trying to count the number of cells that contain certain words, such as "NYSEG" or "RGE," when the cells may contain more than one of these words. I have tried using =COUNT(FIND("ConEd", [Utiliti…
