-
Automate Linked Cells
I have an issue that I've seen in other discussions but I have not been able to figure it out for my situation. I want to automate the process of linking cells from one smartsheet to others. I will provide as much information as possible below. - We have a master sheet, "Project Dashboard" with about 15 columns where I…
-
Conditional formatting
I have two columns in my smartsheet that are dates. I would like to set a conditional formatting rule that says 'If column X is after Column Y then apply this format', is this possible? For example 'If 'Date issued' is later than 'Date Due' apply this format' Thanks
-
Countifs where the criteria is something other than 3 criterion
Hello. I have this formula: =COUNTIFS({Status}, Status@row, {CompanyName}, OR(@cell = "A", @cell = "B", @cell = "C")) that is working to count the status where the company name is A, or B, or C. Now I need to count the status where the company name is anything but A, or B, or C. I'm sure this is something simple, but I…
-
option is not blank + assigned to
I'm trying to count the number of cells in a column "CPS Has Referred Member To:" that are not blank, by individuals identified in "Assigned To" in a sheet summary
-
Need to look for $99,000-$249,000 in Metrics Sheet. Can't find formula error
Need to look for $99,000-$249,000 in Metrics Sheet. Can't find formula error. =COUNTIFS({1. Case Queue Range 6},>"$99,000",<="$249,000")
-
I want to create a cell that will report the # of Status "Complete" If the value in an other column
Hi, I would like to create a summary sheet ((29) GS Bugs/Enhancement summary - Smartsheet.com) . I want to display the quantity of "Complete" from the value Enhancement. Same with "Not Complete" from the value Enhancement And then the % of Complete from the value Enhancement and then for each row.
-
How to search , and match the couple data from 2 sheets and result show on 3rd sheet
Dear All, I'd like to calculate Total stop time of each machines per day. I have tried to find out the solution for search and match the couple data from 2 sheets and result of the couple data show on the 3rd sheet but I am failed. Anyone please help me, how to match and pick up the correct data as example ? Thank you.
-
Update the value of a contact
I am using the Smartsheet Python library, but this could also apply to the API. I am having trouble updating the Assigned To column, which I see is actually a column type of contact list. I have tried specifying a cell value and I get an error message saying "'Value is not supported for this column type. Use objectValue…
-
Feature Request - Please get rid of all the annoying hover boxes.
I've been using Smart Sheet for a few months now in my role. For the most, I like it :) One thing that bugs the living daylights out of me (and all the colleagues I work with), is constantly having hover boxes pop up and blocking out the cells behind. In turn, constantly needing to reposition the sheet (and mouse pointer)…
-
Vlookup Vs Index Match Formula differences
I have used a few sheets using the Vlookup formula and one using the index match formula for the same lookup, it is populating a column on in a sheet using the data in another spreadsheet. What is the difference? I have always used the reference formula, then recently a SS Help Desk person used the index match and I failed…