I have a report page where I've been testing the "Update Request" feature through a custom form. It works well for updating existing information, but is there a way to also add new line items with that request? For example: If I am sending an "Update Request" for a user to review a list of existing fruits and vegetables…
Good morning, Looking for some help on this issue. We have a sheet with hundreds of rows that tally up to a total (1049.86 hours per below JPEG) We need to calculate the % each piece is from the total . These are the children rows. The first formula I got to work by using =SUM([Total Hours Per Peice]42 / ([Total Hours Per…
Hi, I am creating a new sheet that needs to have 20+columns that are all a dropdown column type, with the same dropdown responses. Is there a copy function for setting up the columns? Thanks, Lisa
Hi, I'm Creating my dashbord to manage some sheets. I've already included the widgets but i can't include a standard filter for each sheet. (like in the classic edition page). All sheets opens with filter off. How can I set a standard filter? Thanks
Good afternoon, Looking for some help on setting up formulas to capture the following metrics per attached. Any help would be greatly appreciated. Thank you !
I have one column that shows what a risk is ranked as (a score from 1 to 49 with 49 being the most risky). I am trying to put in another column that lets a ranking for the effectiveness of the mitigation planning (score of 1-5) and then have that drive an auto-calculation of the final score of the Risk. Unfortunately I am…
I've created a table to manage our school-year. Out of this table several calendars should be created. As there is no possibility to create more than one calendar out of one tablesheet I worked with markups and created external links to some other tablesheets so that there is one sheet for every group I have to manage.…
Could Smartsheet add a brief how-to video on filtering to the help article? My team is asking for one and I can make it myself but I think the quality of Smartsheet's videos is excellent and would love to give them something more professionally done. It should demo how to create a filter and illustrate the difference…
I've got an auto-number column in one of my sheets, which has data from an excel sheet that I used prior to smartsheet. Most of the numbers in the auto-number column were from historical data and needed to be identical to that excel sheet, so I changed the column type to text/number, inserted the data with the excel's…