-
Adding text to a field, then changing text color based on calculated values
Hello. I would like to ask if anyone has had an opportunity to have text added to a column, then based on a calculated value, change the text color from say black to red based on a calculated outcome. For example. I have a checkbox that simply determines if multiple Techs were required for a specific task. If the checkbox…
-
While extracting into excel file image is not there. How I get the excel file with complete image?
-
Within the next 7 day issues
Good Evening all, I am trying to do something simple. I have a "Due Date" column. Whenever that date is within the next 7 days I would like it to check a box. However, the issues I am getting are - it is checking the boxes for due dates have no date populated as well as dates that are in the past?? Here is my current…
-
Sheet Summary CountIFS + Date Range
Hi All, Need some assistance. Found a great post & this on the subject but was not able to get my formulas to work. Hoping the group can help. I have 1 working the other is not. Background: Form was converted over from Google Form/Sheets & several formatting changes had to be made in August. (Probably issue #1) Co-workers…
-
Populate a column based on another column with check box.
Any help would be greatly appreciated. What we would like to have happen is when a check box in one of the four columns (NA, GSS Introduced, Customer Accepted, Customer Completed) is checked, it will populate a Completion field in the corresponding row. If NA is checked then Completion = 1 If GSS introduced + Customer…
-
automatically sharing task data between sheets
Is there a way to create an "index" that will automatically link a schedule task and all it's information once it is entered in another smartsheet. For instance, let's say I have a meeting agenda and we want to talk about a schedule task, could I enter it's "index" from the schedule and have it automatically link all the…
-
Auto-populating a range of columns with a number based on dates in 2 other columns.
Hi, I am having difficulty figuring out how to auto-populate a range of columns based on dates from 2 other columns. For example.. A contract's start date is Jan 2022 and its end date it October 2022. The value of the contract is 10,000 USD. I would like to populate columns Jan 2022 through October 2022 with 1,000 USD in…
-
Index/Collect Formula to create a Cashflow by Month...
I'm trying to forecast a cashflow model internally, and I'm having a bit of a brain blank on this currently! The first sheet below details the Project, Total Invoice Amount and four separate payments due with the corresponding months and years for each payment. The second sheet details all four payments by the month/year…
-
Possible method to check duplicate data within multiple columns
Good afternoon, I apologies if there is a simple solution to my question, still rather new😅 Is it possible to create a formula within a checkbox column that would check multiple columns within the sheet against new data within a row, and if all data matches, the box would be checked. For example: An event has been booked…
-
MAX COLLECT where one range has multiple values
Hi, I am using MAX COLLECT to extract from a sheet the most recent date of an event, based on a few criteria. One of the columns can have multiple values (as the source is a multiple value drop down). The current formula is =MAX(COLLECT({Date}, {Blank}, $[Primary Column]$2, {Section}, [S1]1)) where: {Date} = date in source…