-
Merged: Show sheet data in the Form View
This discussion has been merged.
-
Tabs
Hi there, Is it possible to create multiple tabs in one smartsheet, like you can with Excel?
-
Auto fill a second column based on a drop down selection using a form
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one option from a dropdown of ~100 items. That value then populates into a sheet. (This seems…
-
Smartsheet User Names - Resource Management - Temp Contractors
Hello - We have one constant email address that gets used by a few people for specific projects, so it's not always the same person. Contract employees - not permanent. I was told that my recurring error in Smartsheet not syncing to Resource Management is due to inconsistent naming within the sheet to RM. What's suggested…
-
Including a checkbox column in formula returns "INCORRECT ARGUMENT SET"
Hi all, I am trying to make a formula that Calculates the hours spent on tasks with certain conditions. I have 2 arguments in my formula that are currently causing it to return this output. Here is the formula: =SUMIFS({Custom Engineering Requests: Days To Complete}, {Custom Engineering Requests: Drawing Category},…
-
Cells turning "yellow" automatically
I noticed that if I enter a new comment using the little text bubble icon in a row, that cell turns yellow automatically. Why would this be?
-
Immediate Auto-Save
I'm trying to implement a solution for a team that needs changes automatically and immediately saved so the rest of the team can see the changes without delay. Is there a way to set each user's auto-save to immediate, rather than the current 1 minute? Or is there another suggestion for how to setup the sheet so that the…
-
Changing linked Google Drive file names
We have a substantial amount of Google Drive files linked (not attached) in our grids and have encountered a situation where we honestly need to rename them, rename some folders, and move others around - what's the best way to handle a situation like this without fouling up the links?
-
Forwarding Approval Requests
Hi All, I am developing a system that involves a large workflow of approvals. I have it set up so that the user selects a person for each approval to go to. However, I want to be able to have the person who receives the approval, be able to defer the approval to a superior if it is necessary. I found that forwarding an…
-
Custom Formulas or build in formulas for symbol to value conversion
We are currently evaluation Smartsheets (and others) for our team. Smartsheets feels very intuitive. The one thing I like are the symbols for completion e.g. the bar or the pie symbol, but then I'm struggling to use those in formulas. E.g. I use the bar symbol but now want to get to the overall progress for a parent task.…