I would like to set up a single call log, where I could put information into a sheet that would have a cell with a pull down that would populate with unique client names (or ID's) from a column in another sheet. So, when I put a log entry…
Using Smartsheet18Dennis Hoshield
How can I break my sheet up into sections - a bit like swim lanes?
I want a solid line going horizontally across the sheet between rows ideally with a title
Is this possible?
I have a list of Companies and the states they are located in. I want to set up a form so that when the user picks a state, it only displays the companies that are located in that state. Do I have the ability to apply Conditional Logic t…
Using Smartsheet18Loretta Auld
Is anyone else having issues with embedded sheets in dashboards? One i'm working on developing seems to be popping an error every time I save it. The sheet still saves and the functionality is there, but I don't want to scare users with an…
Using Smartsheet12[email protected]
Do you know if it is possible to copy a single row that contains children rows inside, rather than laying out all the children rows ?
Thank you for your help,
Have a nice day !
Using Smartsheet16Corentin Dal Farra
Hi - anyone got a RFQ model plan or WBS to share?
Using Smartsheet10Barry Ingham
Each of my clients has their own workspace with multiple sheets. One of the sheets is a project planner/task list, where each task is assigned to an employee. We have 50 + clients and you have to go into each workspace and click on the pro…
Hi All -
I was wondering if anyone had looked into this - it's kinda of a workaround to a problem I know there's not a solution for. I'm trying to get a Status column changed/updated based on a User submitting an Update Request (to alert m…
Using Smartsheet11Mike Rini
I have a Inventory Sheet with list of items and also the quantity of each item. I also have products that use various items from the Inventory list, for example: Product #1 = 2 screws, 1 sign, and 2 hooks. And the way I have set it up …
Using Smartsheet69Benny Neufeld
We have a 2 week rotating employee schedule and we want to mirror that into 14 daily sign-in sheets for our staff to use daily. We want to incorporate formulas to identifying individuals that are off/PTO and replacing them with Relief empl…
Using Smartsheet20Bhushan Shelat
When using the above automation how do you get the moved/copied row to populate at the top of the destination sheet. When the row that I have moved/copied populates, it is populating on the 25th row of the destination sheet.
Using Smartsheet15Olivia Doiron
Is there a way to send automated calendar invites to something like Google calendar (preferred)?
Using Smartsheet12Victoria Lively
Are you an IT Administrator or do you use Smartsheet for your IT PMO, or are you looking for the best ways to use Smartsheet in IT?
Join us Wednesday, July 15, from 10-11 a.m. PDT for our #CanDoCommunity Live Q&A! We'll have a speci…
Using Smartsheet39Nick Carey
I have several projects that are keep the lights on/maintenance type of projects but I want to show their start/stop dates so that they show up on the gantt view. Is there a nifty way to do this other than just adding maybe EOY end dates?
Does anyone know how to set auto-refresh on published reports?
Is there a way to create an automated appointment link like travel sites do once you book your dates? I created a webform for Time Off requests for our Sr. Managers. I would like to be able to send them a link to add the request to their…
I have an approval request workflow setup that sends data input from a Smartsheet form. Unfortunately, some of our approvers are losing the approval request email in their inbox or not responding to the approval requests in a timel…
I would like to create a tool that creates different Gantt Charts based on the 3 simple parameters chosen by the user.
As a user I want to fill a form where answering to 3 simple questions I get the correspondant Gantt chart according to t…
Using Smartsheet15Sergio Mola
I'm working on creating a Automated workflow so that when I change a status, it triggers an Update Request to someone. I want to set the Status to a Default Value (so the user doesn't have to select something) so it then triggers another u…
Using Smartsheet34Mike Rini
I am relatively new to Smartsheet and would like to present a visual timeline (not a Gantt) on Dashboard. I am unable to find any information on that, but would like to check if any of you have tried this option.
Using Smartsheet16Deepa SP
I am running a 3 stage approval process. If stages 2 or 3 REJECT the approval I have it setup to "Alert" the Stage 1 approver.
I have triggered the workflow now 3 times and each time REJECTED the approval at stage…
Using Smartsheet93Geoff Baker
Cannot send update request to one specific user; testing reveals message re: "recipient has unsubscribed from this action" - how is this opt-out set; is it global across all sheets specific to one sheet; can an admin override?
Is there a way to reneame the error message Smartsheet charts show ("the source data for this chart has been changed") when there is no data in the underlying report it's being driven from? I have set up my charts in such a w…
I have a sheet for a menu of options. We are building kits of different swag items and the sheet has 5 different options with different price breaks. I'd like a sales rep to be able to go in and select different options then see a k…
Using Smartsheet10Jackie Callahan
Im am trying to setup a gantt chart for for our production department but am hiving some trouble figuring out how it works. We dont typically use start/end dates but rather work with estimated hours for a project. What ive noticed is that …
Is there a formula to search a row of dates and return the latest in a column?
My worksheet has 10 columns. My form uses 8. I duplicated the form and I have ready access to the 8 columns in the form but I need all 10 now. I don't know how to pull the additional 2 from the sheet. Any advice?
Using Smartsheet15Carol Krafka
Okay, so here's what I'm trying to do. Our team is using a smartsheet schedule and within that schedule, is a bunch of sub-schedules, that all work together in glorious harmony :)
Up until now, I've been able to use the Predece…
From what I have seen it's not possible, but I can't understand why, is there a way to have the gantt chart timeline displayed only for the period of the project (beginning the first month of the project and ending the last month fo…
Using Smartsheet36Antoine Retaggi