-
Function vs Project Structure
I am a contractor with many projects and I am trying to determine if it is most beneficial to have the individual projects have their own sheet with various silos of activities (in-field construction activities, office deliverables, accounting processes, etc.) and run a report for each team member/silo of responsibility. I…
-
% Complete automatic calculation but restrict the input on the child level tasks
Hi, I have a % Complete column right with automatic calculation of % Complete on parent level tasks. This automatic calculation is based on user input of duration and percentage completion on each of the child level tasks. Now I want to restrict the user input of percentage completion on child level tasks to a certain list…
-
Pulling out data from a master sheet
Hi all, I'm in need of a solution to track activities. There is a master sheet that I have view access to where items get added by different parties. I want to pull out data based on a filter to create a tracking tool to make sure that my tasks in relation to the tasks in the master sheet are completed. Think about…
-
Update Requests sent to some but not others - block?
Hi everyone, I guess my question is: can an external recipient of an update request block SmartSheet emails in a way that would stop SmartSheet from even sending an update request? We have this sheet that sends update requests to email addresses in 2 separate columns. In 99.9% of cases an update request is sent to both…
-
Are Conditions Mutually Inclusive or Exclusive?
Hi all, I have a workflow with various ramifications. I would like to know, with one line of evaluation (which has 3 conditions), will the trigger play if the 3 conditions are met or with only one, it will trigger them? I need the 3 conditions to be met, but Smartsheet just will give the option "Or When" in the conditions,…
-
Operator
Hallo , I have columns A ,B, C. A and B have some formulas. so then it will show some values Now in C column i write formula A+B ... but says Invalid Operation... Is it not possible add two columns which has formulas
-
Navigating to the source sheet from a report
I cannot find a way of navigating from the report to underlying source (apart from sheet name column, which messes up with the presentation - so I typically remove the column form the view). Plus, having the sheet name on each row is annoying. So in few other instances, I grouped a multi-sheet report by sheet name. The…
-
Report not showing Data when a second sheet is added
Hello, I have a report that displays data properly but as soon as I add a sheet, my data vanishes from the columns before I even add any columns from the newly added sheet. I searched for a similar question but those issues had to do with filters but I have none. Why do I lose my data when I add my new sheet prior to…
-
Is there a way to use a form so that it creates a parent row with children rows when it's submitted?
I'm wanting to create a Purchase Order Request Form that when submitted it adds a parent row to a sheet identifying the new purchase order and then has a child(ren) row(s) underneath with the details of the items being requested, kind of like this PO Log Template I found here:…
-
Report Glitch?
Has anyone ever seen a glitch with a report? Maybe its user error lol. I have a report with the following filters However, for some reason it is pulling a line with an end date in March. There is also a sooner date in January that it is not picking up (I wouldn't expect it to since its not in the next 14 days). Any…