-
Contact Database
Hello! I'm new to smartsheet. I was wondering if there was a way to click on a company name and have it display all of the contacts associated with that company? I understand that you can link cells and link sheets but I don't want to create a sheet for each company. We have hundreds of companies and hundred of contact…
-
Linking cells based on matching criteria
I have two sheets, both sheets have a row of column IDs, I would like to dynamically match the column ID from one sheet to the other sheet and then update a row. Similar to the new Lookup fucntion that was recently released but across two sheets. Has anyone developed a solution for this. My only option is to manually link…
-
Sending auto update request based on % completion
Hi, I want to send update request automatically to shared users of that particular sheet after the % completion column is 100%. Please guide me, how it is possible. Thanks.
-
Drop down list central location?
Is there a way to have a drop down list used across multiple sheets refer to a centralized location for the list? That way if the list needs to change, it can be changed in one place and seen everywhere it is used.
-
another day another problem: "Migration User" migration@smartsheet.com??
We run some reports which look for recent lline item changes (past 7 days) in certain sheets. Lately i'm seeing way more hits on these reports than i should. Upon investigation, it turns out something called "Migration User (migration@smartsheet.com)" is making an "update" to several line items. Really nothing material…
-
Autonumbering does not always work?
Hi there I have an order reference column set to auto number. It is prefixed by the date and then an autonumber for the order on that day. For one user the autonumber does not always seem to work, if he creates a new line it uses the same number as the line above. This means we end up with two identical order numbers. For…
-
Auto Number stopped incrementing
Hi I have an auto-number field set on a sheet used for web forms, so that our forms have a reference number. Yesterday, it stopped incrementing, and all new lines were labelled as XXX807. Today, I manually set it to start at XXX808, and sent two test submissions, both arriving as XXX808. Has anyone experienced this? Thanks!
-
FEATURE REQUEST: Save as Draft when Sending Rows
I would like to be able to save a Send Row email as a draft. Why? Sometimes after starting to compose the email I realize I need to change some data in the row. Currently I have to cancel the Send, make the changes in the row and then start my email all over again. If I've written a decent sized body I will copy and paste…
-
Wrike-like, Graphical / Quick Entry View / Single Pane of Glass UI?
Hi, I'm new to SmartSheet. It seems very powerfull, I love the cloud-app integrations, etc. But I find it lacking a Wrike-like or Wunderlist-like view or interface vs the always on spreadsheet-like interface. i.e. The spreadysheet is powerful but I want a single-pane-of-glass view where there's 1) a quick task-entry form…
-
Pulling data from column on drop downlist
Hi, Is it possible to pull the data of "column-1" of "Sheet-1" to dropdown list in "column-1" of "Sheet-2" ? What actually my requirement is: I have a task list defined on "Column-1" of "Sheet-1". I need to create a RFI (Request For Information) webform for site engineers ("Sheet-2") where they select the task list from…
