-
Internal Enterprise Templates
Has anyone developed or use an in-house template area for the Smartsheet solutions created on their account? An in-house "solution center." Our enterprise account has 550+ users. We are looking for a way to share and make available, Smartsheet solutions that have been developed on our account and may be useful in other…
-
Work around to formulas across sheets
I am working with 2x sheets - one a CRM, the other a job list. I would like to be able to flag on the Job list when a customer name is entered which is not already in the CRM. In Excel I could use a combination of ISERROR & MATCH to achieve this, however from what I can work out formulas across sheets is not possible on…
-
[Solved] App crashes in android restricted profile
We've been succesfully using the Android app for about a year. Recently our tablets using restricted user profiles have begun crashing the app upon launch. The admin profile works fine, just the restricted profiles fail. Our current app version is 3.2.0.341 Android version 4.4.2 What I've tried: Cache Purge>reboot Cache…
-
Rolling Up or Consolidating Divisional Budgets
Fairly new user here. Looking for help in rolling up our divisional budgets into a consolidated budget. I have an income statement budget template for each division which has worked beautifully with callaboraters completing their info. These templates (sheets) are all exactly the same format. I'd like to have a…
-
How can I add rows from one sheet to another automatically?
I am trying to create a PO / Invoice tracking system for my team. One sheet has all the blanket PO #'s and amounts and the other has all the invoices that are tied to each PO. So if an invoice is added to the invoice sheet that has a matching PO number to a PO on the PO sheet, the PO amount would decrease by the invoice…
-
Populate Date Column Based on Primary Date Column (taking into consideration workdays)
I am attempting to automatically populate a date column when a "due date" column is filled out. The dependent date column would always be a date 3 working days after the due date unless manually changed. I have been scouring dependency columns and if then statements but I can't seem to figure out something that seems like…
-
Any way to import / paste indented primary column?
Hi all, We often import BOM data from CAD systems to create a working BOM. We would like to import or paste the indented structure into SS and end up with the same indented structure in SS without going through it row by row. Is there formatting we can attach to the import that SS will regognize and indent as desired?…
-
Sales Pipeline Sheet information links to Project management sheet upon status change
Our company tracks sales opportunities and basic project management using Google Sheets. We would like to move this function to Smartsheets. Our basic process: (We design, fabricate and install elevator interiors) A new sales opportunity is logged into a googel sheet and given a status of "Bidding". We also input several…
-
Emailing Sights
I can't seem to find a way to send a Sight as an attachment like you can with reports, is this possible? I need to be able to send sights on a regular basis. This feature would be so much better than having to take a screen shot and attaching it to an email.
-
LOOKUP & MATCH together
Hi everyone, I use a VLOOKUP and MATCH function in Excel to find the intersection of vertical and horizontal values (intersection of a matrix / table). I can't seem to get this working in Smartsheet and need some help. For example if I have Likelyhood = Likely and Impact = Moderate then I want the Criticality to return the…