-
Referencing % in Formula in Symbol Column (RYG)
Is there a trick to referencing % Percentages)when using the If function, automating the RYG symbols in a Symbol column? I have a simple IFย formula referencing cell formatted to %. When I replace the % with any text and update formula to reflect the change, the correct RYG symbol is displayed. When I attempt to referenceโฆ
-
Utilizing IF to open different sheet upon condition
Hello everyone, I have been googling this for a while, and decided it would just be easier to sign up for the forums and post my question. What I am trying to do should be a simpleย IF function statement whereas if a dropdown list entry is hit in a cell, then the user is pointed to another sheet. e.g. Dropdown box 1 onโฆ
-
COUNTIFS on Status and Date Range
Hi Guys I am trying to calculate instances whereby: Status Column = "Scheduled" AND Date Column = date range One of my attempts is shown in the screenshot below, I have tried a few tweeks but can't seem to quite get it right. Any help / advice / guidance would be most appreciated!
-
Turn Date into numeric value
I would like to follow a task and see the difference between when it was planned and actually done. Toย be more precise. Column "Agreed Date"ย is used on what date the two parties agreed to finish the task Colum "Final Date" should show what day the task was really done. This should not change based on date, but should be aโฆ
-
How do I create an IF formula with checkbox?
Hi there! I'm trying to create a formula using a checkbox and I'm really struggling. Using the parameters below, can anyone help me with the formula? Column 1 = Australian states/jurisdictions (SA, WA, etc) Column 2 = Complete column with checkbox PROBLEM: If Column 2 is checked in Row 1, I want Column 1 in Row 2 toโฆ
-
How do I return a date based off of a numerical value?
Hi Smartsheets Community, I have 12 columns that each represent one month and in those columns there are numbers (not dates). Every month I will enter that month's financial data.ย I want to write a formula that tells me which month was the last month to be updated and I want it to return that month's date (vs. a text valueโฆ
-
Saved Filters Issue Date Type Column
I'm running into a very odd issue with consistent filtering on a date column thats being generated from a formula: We have a column labeled "Filter date" that is set to Date (Restrict to dates only not checked) which has the following formula to trim off the date from a 2ndary column that is a drop down: =IF([Dateโฆ
-
Aging formulas in Smartsheet
Hi, I have a column titled aging and its the [created date]-[Today()]. The problem is that there is no trigger when the line item is completed/canceled, as a result it shows that that item is still currently aging in fact it has been completed/canceled. What I would like to do is build if possible and If statement that ifโฆ
-
Conditional formatting for all children?
Hi, we principally use smartsheets to generate Gantt charts for our various projects. Ideally we would like to set up conditional formatting (for example task-bar color) for all of the children of different parents. So for example, let's say "Phase 1" of a project is the parent, we would like an easy way to have theโฆ
-
Formula
This is my current formula and it is working fine. =IF([New/Existing]2 = "New" = AND(Segment2 = "Broker"), 0.4, 0.6) I want to add that if New/Existing is BLANK - to not return anything. Not sure how I can modify this. Help?