Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
¿Hay manera de distinguir si una fila es subtarea o no?In Formulas and FunctionsQuiero que en una columna se muestre un icono sólo si la fila no tiene subtareas ¿es posible con una fórmula? Gracias
-
Populate ColumnIn Formulas and FunctionsI have a sheet named GROCERYSTORE and a column named PRODUCE. I have another sheet named PANTRY and a column named VEGGIES. I want to reference column PRODUCE so those values are pulled into my VEGGIES column. If I later add a entry to t…Answered - Pending Review 7 views 2 comments 0 points Most recent by Melissa_ Formulas and Functions
-
How to keep a cell blank if there is no data?In Formulas and FunctionsI have two sheets a master (2800 records) and a feeder (270 records). I am using the following formula to update a column called scheduled date on the master: =INDEX({feeder06262021 Range 1}, MATCH([email protected], {feeder06262021 Range 2}, 0)) Wh…
-
Workspace Shares - API (cURL) Error 1004 - Not Authorized to Perform This Action - 403 ForbiddenIn API & DevelopersHi all, I'm getting following error when trying to GET a list of workspace shares (GET /workspaces/{workspaceId}/shares) "errorCode": 1004, "message": "You are not authorized to perform this action." The…Answered - Pending Review 12 views 2 comments 0 points Most recent by Thomas Taresch API & Developers
-
Combining multiple criterias with countifs and hasIn Formulas and FunctionsI would like to simplify my formula =COUNTIFS({WK 24 Range 1}, HAS("5:00", @cell), {WK 24 Range 2}, "") + COUNTIFS({ WK 24 Range 1}, HAS("5:15", @cell), {WK 24 Range 2}, "") + COUNTIFS(WK 24 Rang…
-
Metrics Sheet Pulling from ReportsIn Using SmartsheetHello All, I'd love to know if its possible (or a workaround) for creating a metric sheet to use in a dashboard using data from reports. We have 90+ Sheets that we can easily pull data into a report but its hard to get that into a meaningf…
-
Forumla help plsIn Formulas and FunctionsHello, I'm trying to create a dashboard or even a simple sheet that will pull data from my main sheet. Essentially I have a master sheet with Merchant info, Sales Person, Payment Status, and Application status(done or 1of 5 other statuses)…
-
Count if Column has a dateIn Formulas and FunctionsI'm trying to build a ship status sheet and use the sheet summary to give me a count if a certain column has a date. something like: =COUNTIF([Estimated Ship Date]12:[Estimated Ship Date]22, (ISDATE(, "1", "0")) but all…
-
Trying to use IF DATE and auto number together in a formulaIn Using SmartsheetI am trying to link a date column with the day of a plants life cycle. If a plant was "born' on June 7th (Date column), then I want the "Day of Life Cycle" to be "Day 1" and June 8th to automatically populate as Da…
-
Searching formula for index/match, searching for matching value on multiple sheetsIn Formulas and FunctionsHello all, I'm a newbie and am getting stuck trying to find the correct formula to return an ID associated with a person when searching for this person across multiple sheets. I'm familiar with INDEX/MATCH, but am having trouble figuring o…
