-
Setting intermittent dates for a single task
I am just getting started with Smartsheets. So far, I am really liking the ease of set up and functionality. One issue I am struggling with is how to set up intermittent dates for a single task. For example, I have a single task where I want to set a date for every other Friday to meet with the client. I don't want to have…
-
Smartsheet Experts
Hello I have been supporting a company in implementing Smartsheet. Successfully :) Today, I'm getting more and more involved in various other important projects and as a result need extra competent workforce to help me supporting our teams. Any interest? Raoul.
-
Datamesh to Update Engagement Progress for Coaches and Clients
I run a smartsheet for tracking coach/client engagements. There are typically 6 or more sessions in an engagement. Neither coaches nor clients can have access to the sheet. I need the coaches to report the dates of each session in the engagements. Due to the nature of this environment, coaches can report any number of…
-
Does Smartsheet have an equivalent formula to Excel's TRIM to remove spaces in a cell?
Does Smartsheet have an equivalent formula to Excel's TRIM to remove spaces in a cell? Don't know if it's pilot error, a new feature request, or if there's a work around. Thanks! Eric
-
Can I see what resources are assigned to from resource view?
I have a resource listed as 300% utilised on a reasonably large project. I'd rather expected resource view to let me click and list the tasks in question, but it only shows the project(s) involved. Despite the various card/project/etc views I also cannot see an obvious "who is doing what today?" report - I can see what is…
-
#Circular Reference when automating Yes,Hold,No decisions
Hi, Hit a lil road block here. Trying to automate the symbols for my status column based on drop down lists, but i keep getting a circular reference when putting in this formula, =IF([Lead Result]1="Win",Status1="Yes",IF([Lead Result]1,="Negotiating",Status1="Hold",Status1="No")) Posting a screenshot of my sheet for…
-
Autofill Date Column with Conditional Formatting
Hi there, I am trying to set up an approval sheet. I would like my "Due Date Column" to auto fill a date 3 days before the date in my "Date" column only if my "Completed" check box is NOT completed. Can anyone help me with this formula? Thank you
-
Linked Cells hindering form entries
Hi, Facing a problem with form entries on sheet with a bunch of empty linked cells. The webform entries go right to the bottom where the links end. The linked cells are important as plenty of info will be added to it in a single day and it becomes quite cumbersome to keep adding new links as we go. Is there a workaround…
-
Formulas: Countif / And / Children Rows
H E L P! What is a simple way to formulate the "Evaluation" Chart in the Screen Shots attached, based off ONLY the children rows of the 4 Departments on the top of the sheet in both the "status" and "risk level" columns? I'm trying to avoid a "messy" formula but I'm receiving an error through all my attempts.
-
Formula DATE & IF
Hi, I have a sheet that I use for accounts. I have a column for Invoice Date, a column for Due Date and a column for Status. I would like a formula for the status column to read "due in X days" ( a countdown of sorts) if invoice and due date same, read "Today" and once the due date is in the past, I would like the status…
