-
Why does Smartsheet not allow multiple duration columns?
Use Case: Want to log current duration and optimal duration of a task. Want to represent conveniently and have easy roll up. Current situation: Have write formulas and use number column. Sub par experience compared to duration column.
-
Automated Workflow --Multiple conditions with And Function--
Hi, I am trying to create an automated workflow with two conditions and I want those two conditions to be met at the same time, however, I can't seem to switch from "Or" to "And". Notification Type is alert someone and Trigger mechanism is when rows are added or changed. Thank you in advance for the support
-
Gantt chart line for overarching group within a report
Hi All, I have report fed by a data sheet which contains dates for departmental events. These are grouped by department. I have added a Gantt chart which displays the individual lines but i'm wondering if it's possible to have the Gantt data roll up into the grouped Department line. For example, Department A has event 1 on…
-
Question on copy and pasting - keeping formula formats
Hi All, Wondering whether I can get any help with my question below. I have a sheet showing data in relation to a particular investment - lets call it Investment 1 , the formulas are working ok. For the following set of data, i.e. Investment 2 I want to use all of the same formatting as used for Investment 1, so have…
-
Links do not Work
Whenever I publish a Smartsheet, all the links that are in the form of => Open as Smartsheet item does not work, please let me know a workaround on this as it's Important to publish the sheet and also cannot do static linking, Thanks!
-
Linking Schedules to a Master Schedule
Hi Team, My company has a master schedule that is at project phase level (Initiation, Planning, Execution, Monitor & Control and Project close. Is it possible to link in the project schedules (which have the same roll ups) to the master, so that % complete and dates that are rolled up in the project schedules update the…
-
Automatic date fill
Hello, I have the below columns and I would like to add a date column that automatically fills as the days change. is that something can be done?
-
Working with Pictures and Index/Match Formula
Hi, I am building a product basket / configurator where I have a printer engine and I want to add accessories using checkboxes. This part is easy, no worries there. I have a sheet with all the device info I want to use, this is referenced with a cell link, and to start the configuration I select a SKU from the list using…
-
Why is my Download Files link grayed out?
I am trying to download multiple files from a smartsheet into a zip file but when I go to click download files the link is grayed out and I cannot click on it. Any ideas why that would be? I own the sheet so it shouldnt be permissions based. Thanks!
-
Sending Line Item Information
Is there a way to send the information on a line item on a Smartsheet, along with notes and attachments, to someone else via email? What are the requirements necessary to be able to do that and are there different options available?