-
Attachment Permission
Is there anyway to share a sheet but not certain attachments? I have all my sharing permissions set but there are certain attachements I do not want available to certain users. Smartsheet is working great for my team with the exception of attachments.
-
Compare text in two different columns
I have a large SS that includes two rows of columns...one is the listing of the latest print revision, and I want to compare it to another column reporting which revision the part was actually built to. Both of these columns are populated with a letter (NC, A, B....AZ). My goal is a Conditional format color if the two…
-
Planing a load of production
Hello I'm trying to make sheet that I will be able to put orders, amount of planed hours on task and devide for different type of teams, employees. I have stuck on one logic function. At the moment, when not all informations are typed in, function below returns blank cell. =IF(ISERROR(PRORATE($[Total hours]32, $Start32,…
-
Display jobs for the week and who worked on it?
I want to create a sheet that can show the jobs for each week and who worked on it (multiple people can work on it, due to different departments).
-
How to define a default value for a field with a formula
Hello Guys, I am using the webform feature to create the new record for my sheet. In each record, I have cells called Created Date, Closed Date and Duration. And the Duration is equal to a formula which count the gap between Created Date and Closed Date. f(x)=NETDAYS([Created Date]1,[Closed Date]1) The formular is working…
-
Monday of date
I have an installation date column and a "week of" column. In our "week of" column, we keep the date of the Monday before. As an example, if the installation date is 1/19/17, the "Week of" column should be 1/16/17. Or, if the date is on a Monday, (Installation 1/23/17), the "Week of" column should be the same as the…
-
Conversion Formulas / Cell Linking
I am cell-linking 2 sheets but 1 sheet records time in days and allocation: Example: 2 days and 50% Allocation = total of 8 hours spent on the project over the course of 2 days. (The duration can not be changed from days because this is our project management sheet and we use in the gantt chart to share with customers.)…
-
Gantt Chart timeline issue
Hi there, When I try to print a Gantt Chart the timeline is in, say, months or quarters, but when I press the printer icon it automatically converts to a weekly timeline. Does anyone know how to control the timeline when I print? Thanks, Paul
-
Multiple Projects - all with interlocking critical paths
Hello community I don't know if anyone else has this issue. I have multiple projects, resources etc, that all overlap. I have a VP that wants to see the critical path over ALL of the projects. Is there a way to do this? I know we have critical path capabilities within one sheet, but i dont see it in a report when i put…
-
Webform - Enter a default formula instead of value for Symbol data type
I'm hoping someone can advise how to get around this issue. I have a new sheet I'm creating which acts as a checklist in a fixed process. i have several columns which cover off stages in the process, and there is a master flag as well which sets its status based on where there other stages are at. This Master Flag will…
