-
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…
-
Adding IF Contain to a V-lookup Formula
Hello, I can't get a formula to work... I have a VLOOKUP formula that is working correctly in this sheet under "Payroll/Benefits need" column, pulling from a reference sheet which is HR PROJECTS Range 2. =VLOOKUP([Project ID#]@row, {HR PROJECTS Range 2}, 13, false) What I need to add to this formula is... IF the cell…
-
Can we get the date format to MM/DD/YYYY form?
Let me know if this can be done by changing the regional preference. If so, please tell the regional name to go with
-
Where do I find my SS account number?
Hi Can someone tell me where I can find my account number on the SS platform? I cant seem to find mine. Thanks
-
Can we apply rules to repeat form use?
Hi, I have created a sheet to collate feedback on the completion of projects. I've added a copy of this sheet to each project I have, and then set up automation so that each submission feeds into a Master Sheet for PM's to review. It's a pretty basic sheet with only 5 columns, but I'd like the facility to repeat the…
-
Conditionally send reports
Problem: Sometimes my reports have no items as all the actions are closed in the underlying sheet. It is then irritating for my email recipients to receive a blank report. Ideal state: To have two options: Dont send the report if blank or send an automated email still on the recurring schedule stating a custom message…