-
Formula for RYG using % Complete and Finish Date
I am trying to populate my Status field, using RYG formatting (based off the % Complete and Finish Date). I am trying to use an AND/OR and it is not working for me. I can get half way there, but not completely. My Status Definitions: Gray - Not Started Yellow - In Progress Green - Completed Red - At Risk I would like to…
-
If a checkbox
Hello again. I need some help please with automation/formula on a project management sheet we use. (Action 1) I have a checkbox column called "SNAGS" When this is checked, I need a date column called "SNAG ADDED" to auto populate the date in which the checkbox was ticked by the project manager. (Action 2) Like wise, I have…
-
Ability to "lock" rows based on a response in a cell reference
Looking for a way to write a formula to lock rows if a cell has a specific value in it, or hide the rows. Any ideas?
-
How to add time to trigger update request
We have a create date/time column and a status column. The default status when a new item (row) is added is "Not Started". I am trying to take the date/time created, plus 4 hours, and if the status has not been updated I want to generate an update request. Is this possible? I read that the automated update requests can…
-
COUNTIFS formula not returning result
Hello Community! I have a COUNTIFS formula that does not return an error, but it also does not return the result I am expecting. Long story short, I am trying to count how many projects we plan to start by month and year. There are three separate columns that I am pulling from. The column that is giving me troubles is the…
-
Formulas with IF statements
I am working on if I have three sections and I only need to average one section because the other two are null, how can I write this out? =IFERROR(AVG([% Complete]73, [% Complete]76, [% Complete]79, [% Complete]82, [% Complete]85, [% Complete]89, [% Complete]91, [% Complete]92, [% Complete]93, [% Complete]94, [%…
-
Stacked Charts
Hello 1. I am new to the smartsheet community and would like to know if it is possible to plot dates using the charts widget in the dashboard. I intend on plotting a stacked bar chart with dates and duration. (As show in Figure 1) 2. While using the clustered bar charts option, is it possible to a merge the bars, something…
-
Formula Tips are Obscuring the Actual Formula
Hello, Could anyone provide a trick to move the formula tip dialogue box? I am getting an Unparseable error message, but I cannot see the formula to check the syntax (see attached screen shot). Are other people facing this problem? Is it browser specific? I am working around this by copying and pasting parts of my formula…
-
AND not working beyond 2 logical expressions!
Hello I feel like I'm taking crazy pills!!! I have the following formula to change the value of a cell, to encourage the population of cells for a tracking sheet. =IF(AND(ISBLANK(Designer6), ISBLANK([Designer Start]6), ISBLANK([Designer Finish]6), ISBLANK(SME6), ISBLANK(CRE6)), "Pending...", "Click Save to notify!") It…
-
if checkbox
HI, If a checkbox is selected in column "SNAGS" can another column "DATE RECORDED" automatically populate the date in which the checkbox field was selected? Regards Stuart
