-
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…
-
Project with Multiple Dates and Hours
I'm working on a project that I completed over two days and want to document my hours for both days. Sometimes we work on projects over several days in different weeks. How can I enter all this data. Right now I only have one column for Date and Hours. Am I able to add more columns to enter more Dates and Hours?
-
Currency converter
Hi, I have project expenses in different currencies (EUR, GBP, CHF, AUD) and need to convert them all in USD. Is there a solution how I could enter fix exchange rates and after entering e.g. EUR 100.- to get it automatically in new cell / row converted in USD 112.-? I have added the example
-
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…
-
Smartsheet Labs - Map
Love the map feature as a quick and easy way to view all of my companies locations and break them down by state or any way we need. I wonder if there would be any way to get county lines include on the maps though.
-
NEWBIE: Smartsheet Feature Relationships
What is the difference and hierarchical relationships between "sheets", "workspaces", "folders", "sights" and "dashboards"? As a marketing director, product / project manager I am just trying to figure out a logical build sequence for my new smartsheet content. Sheets and folders are pretty straightforward, but what is the…
-
SUMIF from cells with multiple values
I'm looking to pull a budget report that will help calculate the total of a cell if the criterion cell has multiple values. I have a formula that works in Excel, but doesn't seem to translate into Smartsheet. I think my issue is how to specify the correct value for the criterion. Does anyone know the best way to convert…
-
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.
-
Web form question
Does anyone know if the web form functionality will incorporate a slide bar rating scale? This exists in Surveymonkey and my Marketing team still uses Surveymonkey regularly because of this feature vs SmartSheet web forms. thanks!
-
How can I make a "Status" field change "Percentage Complete?"
Hello, I'm wondering how I can sync a dropdown menu (Status Column) to another column (Percentage Complete). Ideally, this function would change the Percentage Complete column to 100% when the status is marked "complete." Thanks in advance for your help with this! - Mike
