Formulas
Discussion List
- Column reference is [Open Days]@row If the number of open days is =< 7, I would like it to show the Green symbol, if between 8 and 29, yellow, and >= 30, red. Thanks!
- I am creating an simple method to help us determine project progress to report back to our customers. The idea is to group tasks into phases and then classify each project as being in a specific phase…
- I need to include a formula in a form that shows a percentage based on values that a user will input when filling out a form. I need to do this because other questions on the form will depend on the v…
- Hi All I am trying to retrieve results from several columns on a seperate sheet into 1 cell on another sheet. This formula works - =IF(INDEX({SUS Badge}, MATCH([Full Name]@row, {SM Name}, 0)) = "Not a…
- Hi, Trying to get some counts for a report and have run into a bit of a road block. In excel, I would typical use a count formula and a wildcard. However, Smartsheet doesnt seem to have the capability…
- Greetings colleagues - I'm stuck and could use some help. I have a checklist that needs to calculate the Start and End time (hh:mm) given the first start time and duration in minutes for each step in …
- Hi! I'm stumped on this one. I am using a column formula to apply a date 21 days prior to the date in another column. Everything (formatting, etc) is the same on all the rows, but I keep getting "Inva…
- I included all this information in the snippet but here is my issue. The issue is I cannot get a formula where the "Risk/Issue" column identifies whether it is a RISK or an ISSUE or an RISK BECOME ISS…
- I've got formulas that return a result of a specific number depending on different keywords in certain cells on the spreadsheet. That's fine - they all work great! My problem is that I'd like to use t…
- Hi everyone, I need your help to calculate the maximun data for each resource, starting from a sheet where the activities are recorded. I have a sheet where I write all tasks for each resource: I need…