-
Amount in negative
Hello, How can I show the amount in negative when the status changes. For example, here in the screenshot, the red highlighted one has the status 'OUT'. I want the amount to show in negative in the next column. Thanks
-
% Complete Forecast to Future Date
Is there a way to project a POC (Percentage of Completion) to a certain Date? The assumption is that the baseline schedule has been vetted, and agreed upon. What I would want to do is forecast for example what the POC would be to the end of the Month, or to the end of the Next Month - I'm at May 30th right now, so I can…
-
Value if cell contains text
Hello everyone, I'm french so sorry for my english... I want to return the city name if the "Territory" column contains T1 or T2... Knowing that I use a correspondence sheet: T1 = PAU; T2 = Toulouse; .... =IF(ISBLANK(Territoire@row); ""; JOIN(COLLECT({City name Plage 3}; {Correspondance Territoire Plage 4};…
-
SUM and INDEX combination formula
I have this formula that works in Excel, but when I try to rebuild it in Smartsheet, I'm getting an error that it's unparseable. How can I do this in Smartsheet: =SUM(C3:INDEX(C3:N3,$C$2)) I've gotten here in Smartsheet, but it doesn't work: =SUM(January@row:INDEX(January@row:December@row, 1, $January$1)) I would like to…
-
IF, AND formula for checkbox
Hello, I'm trying to make a formula for a checkbox column where if the column titled "Expected result" is positive, but the "Results" column is negative, then the checkbox will be filled (and vice versa if expected is negative and result is positive). However, I cannot say if the expected result column and results column…
-
need to have a formula auto fill but only if there are dates in specific cells
I am trying to get the cells to auto fill depending on the dates entered next to it. I can't use the convert to column formula feature because it's not a guarentee that all data in the start date and end date will be entered. We are doing a market review for a certain group of team members and need to let them have the…
-
Using OR/And Function
I am trying to create a formula for the following: 45 days before the deadline – where work is completed less than 65% - Red alert 65-75 % - Yellow Alert 75% more – Green Alert I am not able to combine two Parameters to determine the colours. See an example =IF(OR(AND([Revised Planned Finish]@row - [Revised Planned…
-
Bulk Updates
Hi, I have multiple sheets that is getting data with formulas from one specific sheet that gets updated 3 times a week. I'm calling this sheet as the bulk update sheet. Since SmartSheet doesn't allow to import from excel on that particular sheet, let's say override the existing, all the time I need to copy paste all the…
-
Formula Criteria - IS ANY OF based on Multi-Select Dropdown
Hey, So I'm going to guess that the answer is no, but I'm going to hope the answer is yes. We have a board that is used to help track hot or critical inbound items. The goal is to retrieve dates from our, lets call them 'Build Trackers', based on a series of criteria in order to help inform the priority and urgency of…
-
% Allocation Formula for Assigned To column
Hi @Genevieve P. Can you please help me come up with an IF formula to use in the % Allocation column for my sheet? This is what I am trying to formulate: If Bob (from the ‘Assigned To’ column) reaches greater than 100% allocation (from the sum of multiple rows), make the ‘Assigned To’ cell Fill in Red for wherever Bob’s…
