-
Assigning a task without sharing a document
I have an ongoing task list for myself. I do not wish to share it with anyone but want to assign people some tasks. I know I can share snippets of my sheet. Can folks reply via email and it updates my sheet?
-
Programming with Smartsheets
Is there any way that I can use external programming to effect my Smartsheets. Is there an API that would let me right seperate programs to control my Smartsheets?
-
Cell Link or Formula for Start and Finish Dates
I'm looking to find a solution to populate the start and finish date columns based on info in another sheet. However, because I have dependancies turned on the date columns cannot use a vlookup or other function to pull the dates from another sheet where they are stored. Here is the basic setup: Grid 1 includes dates…
-
How to Record and compare previous status (stoplight color or dates)
I have a report I'm trying to emulate in Smartsheet. The report has critical milestones in column a, and stoplight colors in Column b, and c. Column b shows the prior week and Column c shows the current week. The intent of the report is to show if a milestone has trended the same, improved, or gotten worse by comparing the…
-
Red, Yellow, Green, Blue
=IF([CEO Approval to Re-Open]@row = "Approved", "Green", IF([CEO Approval to Re-Open]@row = "Declined", "Red", IF([CEO Approval to Close]@row = "Declined", "Yellow", IF([CEO Approval to Close]@row = "Approved", "Red", ISBLANK([CEO Approval to Close]@row = " ", "Blue", ISBLANK([CEO Approval to Re-Open]@row = " ",…
-
Parse text from large string
@Paul Newcome - I've read a lot of your discussions throughout the years and you are the MAN! I have a question down below and hoping you can walk me through it. I'm simply not that good at this particular formula design. I have a SF Connector setup and it pulls the below string. The total character length of the string is…
-
Duration Counter/Timer
Is there a way in SS, that when using an auto-generated created date/time, that a duration column will count how long since it was submitted. Then have a date & a time column for completion that will stop the timer?
-
how to sumifs
This discussion was created from comments split from: How do you add 2 SUMIFS in same function or SUM of Range based on 2 values in SUMIFS Criteria Range?.
-
Count Netdays if Project Status is "Complete"
Hello Forum, I am having difficulty writing a formula to count NETDAYS if a project status is "Complete". I hope this is not too confusing, but here goes..... 3 COLUMNS: "Project Status", "Actual Start Date", and "Actual End Date" I have a grid with 200+ projects/rows (Project Intake Sheet), and would like the formula to…
-
Does anyone have experience writing formulas to assign "deciles" to a range of values?
I have several series of different ranges of values that I am seeking to "decile" - i.e. rank order the values from largest to smallest value, take the Total Sum of the range, and for rows that sum through the first 10% of the Total Sum assign a "10", for those rows that sum to the next 10% of the Total Sum assign a "9",…