-
Cell Linking from a Form
Hello I am trying to do cell linking from when the information is entered in from a form rather than directly onto the sheet itself. When I do this it adds the information onto the sheet however it moves the cells I am trying to link down to the next row and will not transfer over the information. Is there a way I can do…
-
Default view when a user opens a sheet
Hello! What is the default view for a unlicensed user when they open a sheet? (In regards to collapsed and expanded rows) Is it the same as the last way they viewed it, or how the last user had viewed it? Here is the specific question from my colleague: "Usually when I'm done with a set of tasks I like to collapse them…
-
How do I count how many projects are "In Progress" or "Completed" ?
HI There, I feel this should be easy to figure out but i cant seem to! PLEASE HELP?! I have a column called "STATUS" , I have a drop down menu with the following under Status STAUS On Hold In Progress Cancelled Completed How do I show / count how many projects are "on Hold" or "Completed" or "Cancelled" Ideally this will…
-
Status Circle Automation
Hi, I am using status circles for a high level status report. Is it possible to automate the 'Overall' Status Circle based on the colors in the other measures (budget, timeline, scope, KPIs, value). For example, if 4-5 of the metrics are green, Overall is green. If 3/5 are green, Overall is Yellow. If 1-2 are green,…
-
Due Date Automation for Tasks
Hello: I have 2 quick questions regarding how to best automate/populate dates for project management timelines. Is there a feature (or formula) within Smartsheets that allows you to specify if a task is a reoccurring item? For example, if on the last Friday of every month, we are to pull a client report, how do I set that…
-
3 condition formula- Help
Need help with a formula, 3 conditions- 1) Recognize first 3 digits of "ticket number" (EX: "LEG", "ONB", "REV") 2) Recognize when a task is past due 3) Status not "Complete" or "Not Applicable" What I have so far: =COUNTIFS({KIM- Project Plan- TEST Range 3}, "LEG", {KIM- Project Plan- TEST Range 1}, >TODAY(), {KIM-…
-
Can Formulas Reference Reports?
I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person. When I go to do that and the formula asks me to reference a sheet, I am only…
-
Delete and Lock row
Dear All I would like to know. Is it possible, if I want my team can edit the row but they can't delete it?
-
Workaround for all attachments sending in Update Requests...
Does anyone have a workaround for not wanting to show all the attachments for a row when an Update Request is sent with the option to attach a file? I am using Smartsheet to track RFPs and the information for each one is collected into one row on a Master Sheet using a form. This information will sometimes involve multiple…
-
Specifying a day to use with predecessors
Hi folks - Anyone know if it's possible to specify a day for an activity to happen in a sequence, when using predecessors in project plans? We have an IT review process that only happens on Mondays, and I'd like to set the predecessors for that task up to be the first Monday after the previous step is complete. Everything…