Product questions?
Ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Data Entry With a Filter
OK - I have a sheet that tracks our invoices by VENDOR. We have several vendors in alphabetical order as the "parent" rows and underneath each vendor are their respective invoices (children). The sheet is long so I create a filter to pull up a specific vendor. In the first blank row under that vendor I type in the…
Can I connect and initiate a Datamesh config using Zapier?
Can I connect and initiate a Datamesh config using Zapier? Every time I add a new row to Sheet A, I'm using Zapier to create a new row in Sheet B. Sheet B has other columns that need to be updated from Sheet C, by "joining" specific columns in Sheet B and C using the Datamesh. How can I achieve this with Zapier or…
question about countifs
I'm trying to count the number of checkmarks for departments. Essentially, for this screenshot, the Academy project has people from different departments participating. I want to know how many people from each department are working on it--a count of each. That way, when I add more people to the project, the total counts…
Update Jira issue sprint from Smartsheet
I would like to update the sprint of a jira from smartsheet. I get this error when I try Invalid response from JIRA. statusCode: 400, reasonPhrase: Field 'customfield_14605' cannot be set. It is not on the appropriate screen, or unknown. How can I fix this? Thanks
Help with formula
I have 3 sheets. * Summary Sheet * Sheet 1 * Sheet 2 I want to take a cell on sheet 1 * cell on sheet 2 and return it to a cell on the summary sheet. I have done it in the past but something seems to have changed and now I can't figure it out. Should be simple!
Salesforce Connector currency conversion
I am trying to pull a report using the Salesforce Connector with currency converted to USD. I know the field names, but they don't seem to be available for the Opportunity object. I checked and I do have permission to view and edit the fields in Salesforce.
Group Management
If I create a Group in Group Management, why can I not attach a Group to a Contact List. My Groups are various Teams in our organization and within a sheet line item, I would like to select my Team (Group) as the owner. I know I can have a Contact List and select multiple names, but I would prefer to add those names in the…
IFERROR
HI all, I have a sheet where I am collecting data. One is our overall variance. In certain rows I do not have data and receive the #DIVIDE BY ZERO message. I have attached the screenshot to show my formula. Thank you,
Finding the annual Quarter of a corresponding date
Since SmartSheet doesn't seem to have a roundup function, can anyone help me to calculate the annual quarter from a coresponding date? in excel i would use something like: =roundup(month(cell where my date is)/3,0)
Please Help with Summit Formula
I want to if assigned person is correct to then take information from one cell and transfer to a different cell automatically? This is the formula I have so far however when I enter this it gives the #unparseable error =SUMIF([Fielder Assigned]:[Fielder Assigned],"Name",[Rural Mileage]:[Rural Mileage)

Popular Tags

Trending in Smartsheet Basics

Move Row Automated Workflow moving ALL rows regardless of criteria
I set up a workflow to move rows that are marked Closed to a Closed sheet. However, the trigger does not seem to work and when I force run the workflow, it moves all of the rows regardless of what is in the cell. What am I doing wrong?
Search a string and return multiple results
Hi experts, I have a formula that searches a string for a keywords, in a string that may include more than one result. It only returns the first instance found. Is it possible to have it continue searching and return all found keywords? Here is what I have currently…. I am looking at JOIN(COLLECT, but not clear how to…
Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags