-
Podio and SmartSheet
Is there a way to push projects from SmartSheets to Podio?
-
RGY Status - Overall Roll up
Hello helpful Smartsheet-ers! I have several rows that are utilizing the RGY buttons for health. I am trying to roll these up to a general status based on the choices in the individual rows. Can anyone help with a single formula that would capture: Green if all elements (rows) are green Yellow if one or more elements are…
-
Lookup text or number in last cell
Hello, I know how to do it on Excel, but cant seem to get it to work on Smartsheet. I have sheet that gets updated by a form filled out by other people. I would like a formula that would get the last piece of information added to particular cells in this sheet (add to bottom row) and display this in an overview cell.…
-
Referencing a Column in Another Sheet
I am having trouble referencing a Column in another sheet through an IF formula I am trying to do. My current formulas is =IF({Sheet 1 Range 1} = 1, {Sheet 2 Range 2}). The first Column I am referencing is a Checkbox Column, and I only want it to return the value in Range 2 unless Range 1 is Checked. Whenever I do this…
-
Form Confirmation Options
Is there a way under the Form Confirmation Options to show a confirmation message AND include a hyperlink to a Smartsheet? I see the box accepts HTML code, but it doesn't format correctly.
-
Dependent tasks should not be forced to follow
Hi all, When 2 tasks are created and task2 is made dependent on task1, task2 is automatically moved so it follows directly the end date of task1, and there is no way I found so as to create a time gap between the 2 tasks. My team often wants to work on yet another task, say task3 and have task3 worked in between task task1…
-
SmartSheet vs AutoTask feedback
Hi SS friends! I was hop to get feedback from the community on advantages or disadvantages of SmartSheet vs AutoTask. My company is utilizing both products now and I'm curious if both are really needed. Thanks!
-
Resource Pool Management
I am in the process of setting up a Resource Pool of named resources to support a number of Projects. I need to indicate, for each individual resource, their availability to work on projects (e.g. Leave Periods, Working Days in a week (for part-time staff). I don't believe I can do this within Smartsheet as these details…
-
COUNTIFS problems
I am doing a metrics sheet to give department heads better visibility on our workflow. One of the metrics I need is how many items have been shipped, but not yet invoiced, I have a date shipped culumn (date) and an invoiced check box (boolean). Several other formulas have similar setup criteria and are also not working.…
-
Create Group Contacts
Hello - I am a PM for a large org and need to request updates. How do I create groups? Sometimes I have 40 plus team members. My question is - I am not a group admin - Can I create groups to help streamline my updating process? Thanks in advance!