-
RAG Status by Percentage Complete and today's date
Hi Query I have a formula for RAG status which I've been using to manage performance across multiple projects looking at the columns end date, % complete, and referencing today's date. However it is not working as planned and wanted to ask for some help please. I would like the formula to simply change the RAG status for a…
-
Smartsheet and Tableau: Can someone connect a sheet with Tableau with viewer permissions?
Hello, I'm looking into connecting my Smartsheets with Tableau. I have a tableau license and I am the owner/admin of all my sheets (business plan). For other users, do I need to set up the Smartsheet/Tableau link for them? Can other users create visualizations via Tableau if they have a tableau license and have viewer…
-
Easy way to express Monthly Data
Hi all, I have started a project to use Smartsheet to track Right First Time across several departments. As part of this I want to track the data on a monthly basis. The form uses a 'Created date' field to input the date when the entry was submitted. Is there a way of expressing the date, so I can use it as a COUNTIFS…
-
Nested If statemens
I've read various posts on the forum and have been able to fix a few of my issues but I can't seem to get past this one. To show the stage of a project is in a workflow, I am using various IF(AND(NOT(ISBLANK, meaning that stage has been completed. So, if the Outreach stage is complete, it will not be blank, etc. In my AND…
-
formula running the status column
This is the formula in status. The issue is that if the date is TODAY either in START or in END Date column the status turns to NOT STARTED. I need the status NOT STARTED only to show up when the start date is in the future =IF(Level@row <> 0, IF(Level@row <> 1, IF([End Date]@row = "", "", IF([Canceled?]@row = true,…
-
Cross Linked sheets Need to be Empty each Monthly
I have a sheet which I save as a template which is cross linked to another sheet where fresh data are inputted on a monthly basis. Is it possible to keep the 2 sheets continuously linked together so that data can be inputted monthly. The sheet where the data is inputted needs to be empty each month and at the same time the…
-
Effort Driven Task
How do i make the end date and duration autofill, if for example i say i have 5 days effort to deliver and im 50% assigned to the task ?
-
How to add new criteria to my current COUNTIFS formula?
Hi all! Not sure how to add the criteria do not add to count if cell = "Topic" to my current COUNTIFS formula. Current foluma is: =COUNTIFS(CHILDREN(Plan:Plan), "Fundamentals", CHILDREN(Role:Role), HAS(@cell, "IBX Customer Ops")) I need to add 'AND if the the "Deliverable" cell does not equal "Topic" '. Thanks in advance :)
-
Formula Needed
I am tracking attendance for meetings I am doing. I need the DC # to automatically fill in when I type the name in . The data is already in another sheet, I just need the DC # that matches the name to be filled in. I am Including two screenshots. The first is where I need the formula. The second is the sheet the data is…
-
Summary Sheet formula to count status by assigned person
Hi All, This should be a basic formula but I cannot seem to make this work for me and I am hoping that someone in the community can help me pinpoint where I am going wrong? I entered this in the sheet summary field - =COUNTIFS({Range - Standard Author}; StandardAuthor@row; {Range - Status}; "In Progress") noting the…
