-
Tracking Survey Data in Report for Dashboard
Hello! we are sending a survey out to our entire team using a smartsheet form, and I've been asked to create a dashboard to track the results. We are attempting to capture in report (for a DB) the following: Percentage of Direct reports who have completed the form for each leader Percentage of how many answers within each…
-
#NO MATCH Error on INDEX-MATCH
Hi, I have a Master Project Directory (MPD) that is a consolidated register of all projects registered with each company associated to our Group of Companies - each with their own project numbering system. Because of this, I created different Auto-numbering Sheets (ANS), each with their own autonumbering column. Workflow:…
-
Filters
Can someone reach out to me? The highlighted sections is stuck on this dropdown. It might have been me. We have a new software that keeps our pw and i click on it by mistake and now it wont change. I need your help ASAP.
-
Smartsheet Python API to create a link from one sheet to another.
This discussion was created from comments split from: Add a link to an existing cell that has validation turned on -- want to override the validation.
-
Is there a way to show an exact percent in Smartsheet?
Hello, Looking to show a completion chart that corresponds to % Complete in my chart. What would be the formula to show 0, 25, 50, 75 and 100% complete that corresponds to the Completion graph that shows the similar amount completed? (Far right column needs to correspond to the far-right column). Thanks!
-
Help with a complex Mutli Select Drop down formula!
Hello! I have a sheet which is connected to a form where the user can enter what services will be required (as a multi select dropdown option). What I want to be able to do is reference another sheet that has a 'practice' (line of business) that the service is related to and return all those values inside a second drop…
-
Best way to capture data from the field
Attached is a picture of a daily report form that we capture from each crew on a daily basis. These are done on paper and handed in weekly. Looking into how we can utilize smartsheets to get this information on a daily basis and digitized. My first thought was to create a form to gather all this info, I soon realized I…
-
How do you spread costs evenly across months of project?
I did some searching on this topic and came across a couple formulas that I've tried and I must be missing something. The formula I've used is as follows: =IF(AND(MONTH($Start@row) <= 1, YEAR($Start@row) <= 2024, MONTH($End@row) >= 1, YEAR($End@row) >= 2024), $[$/Month]@row) As long as the start and end are in the same…
-
API AttributeError: data
DEBUG:smartsheet.util:object 'Sheet' is missing property 'resource_management_type' DEBUG:smartsheet.util:object 'Sheet' is missing property 'cell_image_upload_enabled' DEBUG:smartsheet.util:object 'Sheet' is missing property 'is_multi_picklist_enabled' Traceback (most recent call last): File…
-
How to count the number of photo shoots, not completed, by brand? COMPLEX???
Trying to get the summary of the amount of photo shoots from one column, not checked completed from second column, and sorted by the brand by third column. So three columns. (Brand column with specific brand) + (OW Shoot Date column) + (Photo Shoot Complete column) = Total shoots by brand.