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
-
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…
-
if the answer is zeroIn Formulas and FunctionsWhats the correct way to do this? =if(SUMIFS({Service Projects Tracking Master Log Range 1}, {Service Projects Tracking Master Log Range 2}, AND(@cell >= DATE(2021, 8, 1), @cell <= DATE(2021, 8, 30)),0,75,000)Answered - Pending Review 12 views 4 comments 0 points Most recent by Samuel Dowdy Jr Formulas and Functions
-
TrackingTime How to have TrackingTime create a project from a task in SmartsheetIn Premium Apps and IntegrationsIs anyone familiar with TrackingTime. I am fairly impressed with TrackingTime and intuitive and efficient concept of having a button in my task row in SMartsheet which interactively starts and stops time tracking in TrackingTime. I just h…
-
Formula for Payment Terms "Net 10 EOM"In Formulas and FunctionsI'm trying to write a formula to calculate a payment due date using the payment terms "Net 10 EOM". Meaning if invoice is submitted by the end of the month, its due by the 10th of the following month.
-
SUMIF with criteria as a numberIn Formulas and FunctionsI'm trying to do a simple SUMIF formula but it isn't working and I think it is because I'm trying to use a number as the criteria. But I would think there is a workaround. My main sheet has data like the below, where the same C/M is listed…Answered - Pending Review 7 views 5 comments 0 points Most recent by Bassam Khalil Formulas and Functions
-
Conditional formatting for entire sheet instead of columns?In Formulas and FunctionsI have a grid set up to track the status of 12 different steps in a process for 10 items. The rows list the individual items, the columns track the status for each step. I want the cells to light up based on the status - Not Started = grey…Answered - Pending Review 9 views 1 comment 0 points Most recent by Bassam Khalil Formulas and Functions
-
Forms Announcement: New enhancement for conditional logicIn Using SmartsheetHi Community, As the PM for Smartsheet forms, I read and appreciate every piece of feedback that you submit. Since we released conditional logic for forms last spring, one of your most frequent requests has been the ability to conditionall…
-
Excel refresh failure while uploading on teams or sharepointIn Using SmartsheetI am downloading the reports from smartsheet to excel with the help of data connector.There is no issue when refreshing the connection in my local drive, but getting error "Failed to refresh error" when I upload the same file in…
-
Find the unique dates from a sheet AND display them from oldest dateIn Formulas and FunctionsFrom a previous post I can find all of the unique dates from a sheet within the last 45 days. My problem is that the dates are not listed from oldest to newest, so when I add this information to a dashboard it does not display correctly. H…
-
Identifying Duplicates in a columnIn Using SmartsheetHi, I am trying to identity duplicates in a column on a smart sheet but I don't think I am doing to formula correct. I did add a flag column and tried to enter the formula in there but its not working. I want to identify if there are a…
