I have a smartsheet that I would like the following steps to take place automatically. I have the following columns Percent Complete column which has symbols in it. Resolved column which is a check mark. Completed column that is a date. I would like to do a function in one of the columns in the row and have the other 2…
I want to do something simple but can't seem to figure it out. In a summary, I want to display the number of "Calls Made" for the current date. In other words, I want to display the number entered in the "Calls Made" column for today. Which function would work best for that? Thanks
Hi, Once you select "dependencies" on a sheet, it says that the top level rows are supposed to be shaded in grey. This is not happening for me. I also wanted to conditionally format so that various levels have a particular background color. I know it can be done because someone at SmartSheet once showed me - but it's been…
Hi Team, I was trying to create summary sheet by doing a reference to a report which is a consolidation of multiple sheets. I don't see reports when looking to reference. Is it not allowed? Is there any work around? Kindly suggest.
I have a quick question. I have 2 sheets (Sheet 1 and Sheet 2). In Sheet 2, users submit a form and a field (which is hidden) is automatically checked indicating it's been submitted. What I'm wanting to do is - essentially - notify Sheet 1, that a user submitted something on Sheet 2. My first thought, is to use a VLOOKUP…
I'm having trouble coming up with the correct function and am hopping someone can help. I have Sheet A that contains the data show in screenshot below. I also have a Sheet B, where I am trying to pull data from Sheet A, when I reference a 'Project #'. I want the name of the Salesmen & corresponding Amounts to show in rows…
My team wants to track the average day count that that a customer request has been open based on the request type. My formula is: =AVERAGEIF({Support_Case Age}, {Customer Support Range 1} = "IT Request") What I want is the Average of the {Support_Case Age} column, if the value in the {Customer Support Range 1} is "IT…
Need to count "completed" and/or No action needed" values in one column. not sure how to write a count formula to perform an or count.
Hello, My % Complete column is not calculating. I think I have it configured correctly but I am not sure what else to look for!
My options in my first column (Change Type) E-mail Change, Phone Number Change, Trainer Change, Department Change, Shift Change, and Pay Change. In my next Column (Approval Required) I'm trying to get it to show whether approval is required or not which is not the case for E-mail or phone number change. I have have tried…
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
When I look at my Calendar, I see the filters I created, but someone else without or with an SM license can see the license.
Hello! I am using an Index & Match formula to populate the following fields based on the chosen Integrated Participant: Group, RHMID, Class of Trade, and GPO Start date. I want any blank cells (aka, data not assigned to an Integrated Participant) to display #NO MATCH. I am using IFERROR statements (below) that will return…
I want the values of the columns to be automatically the same all the way down the sheet unless I change the values. As new entries come in from the form it should automatically put in whoever I have listed.