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
-
I have one column Miles and a second column Billable miles.In Formulas and FunctionsMILES BILLABLE MILES (RESULTS) IF miles is > 1 miles -500, if miles < 500 "N/A"
-
Basic checkbox counting to apply status option to Parent rows onlyIn Formulas and FunctionsI am unable to get the output to say "Not Started" in the Status column for the formula I am using. What is missing? Also, is there a way to reference "Done" part of the Children of the parent without specifying the exa…
-
Automation SettingIn Using SmartsheetHi All, I am trying to set up an automation for a reminder When Action Due Date is reach and all other actions due date that's in the next 30 days (or within that month) and status active, send an reminder email. I tried many times; howev…
-
Using Countif in place of Autonumber - formatting question!In Formulas and FunctionsI'm creating a ticketing system with multiple prefixes. Because of the multiple prefixes on one sheet, II opted to create a nested formula to number the tickets based on the various types of requests. Here is the formula: =VLOOKUP([Request…
-
Counting values within multi selection dropdown columnIn Formulas and FunctionsI used a multi selection dropdown column to select each company that sent in a bid for that project and I want to keep track of the total number of bids sent for each company. The formula I used is COUNTIF({Architect Selection}, "BSA&…
-
Index/Collect that should work, but is not returning values.In Formulas and FunctionsHello, Community! I've tried support and Pro Desk so far without success and could REALLY use your collective brain power. Here's the situation: I'm trying to use Index/Collect to bring the value of A into D where the Year for Role = 0 and…
-
Return ALL ID#s from another sheet if other Sheet equals "specific name"In Formulas and FunctionsHello Everyone, I am brand new to using smart sheets. I have a lot of experience us PBI but not as familiar with the smartsheet formula writing. I have a completely blank sheet and also a roster sheet with ID numbers and location names. Wh…
-
Using a form to sign up to conduct trainingIn Using SmartsheetHello, The process I am trying to create is as such: I need a way for two different levels of employees to be able to sign up to conduct training classes. The classes are mostly different for each employee level, but some overlap to both …
-
How can I get rid of rows that are not applicable?In Formulas and FunctionsI am creating a report with any upcoming tasks that are due within the next 14 days. However, when I do that, it pulls in my entire sheet, even rows that are in the future and not within the next 14 days. How can I get this to only show ta…Answered - Pending Review 12 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
SUM and INDEX combination formulaIn Formulas and FunctionsI have this formula that works in Excel, but when I try to rebuild it in Smartsheet, I'm getting an error that it's unparseable. How can I do this in Smartsheet: =SUM(C3:INDEX(C3:N3,$C$2)) I've gotten here in Smartsheet, but it doesn't wor…