Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Feature Request- row by row work weeks
I need to be able to assign different work periods to different line item tasks. We have some subs that work 8hr 5 day weeks and others that we accelerate for some work to do double shifts or 6 days a week. We also at times will add saturday to a sub for a period of time and then switch back to 5 day. Currently if I change…
Insert a Parent row when cell value changes
I have a very long sheet where I need to group by the key column, so I have to insert a Parent row for every different value en that column, how can I do it?
Formula to change date based on adjacent drop down menu
I'm trying to set up a tool inventory, to help keep track of the location of all our big ticket items. I've created a row for each tool. Asides from various descriptive colums, I have one column set as a drop down list (listing the numerous job sites the tool might be pulled to). I also have a Date Pulled column, to show…
Pictures and Webforms
Hi, I would like to be able to take a photo and include it in a field of a Webform. eg: Safety visit of a site - we detect a breach of safety, want to record it, with time/circumstances .... and photo evidence eg: Recrutment tracker - we interview the person in a place and want to add the photo in the tracker ... It…
record the date when 'done' is checked
I really miss a solution to automatically record the date when the 'done' checkbox is checked (without entering it manually) This is fundamental to calculate and make some stats about the lead/lag between planned and achieved date. Woud love to know it is part of the development road map. Please like this if you share the…
Adding an Primary Column item, which then updates another sheet.
Whats the best way to organize sheets so that when I add a new row (Primary Column item), it gets added to a corresponding sheet? For example, if I was to add a new person in our firm, I would like that person to show up across 2 other sheets as well.
Cell History
Hello everyone, Does any way to share a sheet with external people without sharing the comments and cell history ? Thanks in advance for your help Olivier
Help with SUMIF
Hi I am calculating time spent on work by Job Number and by Date I have set up a SUMIF formula to add time spent by job number: =SUMIF([Job Nº]:[Job Nº], "64501", Time:Time) - Works fine. the formula to add time spent by date is: =SUMIF([Job Date]:[Job Date], "30/03/17", Time:Time) - and the calculation comes out as "0"…
Collaboration between two client who both use SmartSheet
Looking for suggestions / best practices to make the most of SmartSheet with an important client who is ALSO a huge SmartSheet user. First step they requested is a simple file repository - will grow from there...
Willing to Pay for a couple hours of formula setting
I am rookie and have never used formulas. Willing to pay someone to set formulas in a project for me that has 15 sheets.
