-
Update invoice status using multiple IF statements
Hi there! I have the following columns: Actual Invoice Date, Due Date, Invoice Status and, Days Past Due. First, I'd like to have the Invoice Status display SENT if there is a date present the Invoice Date column and then have it display PAST DUE if the date in the Due Date column is greater than today's date. I know these…
-
How to copy a parent row through automation without also receiving children?
I have tested several automation options and am unable to only copy parent rows. I can set the criteria to only copy a single or multiple children without parents but, only want parent rows of data to be copied.
-
Using VALUE within an IF formula to covert text to number
Hello, I've determined the issue with this formula is that the cell it is pulling from is formatted as text, not a number. I know I need to use the VALUE function to correct this, but I've tried this many different ways and cannot get it to work. This is my original formula: =IF([Projected SI %]1 = 0, "0", IF([Projected SI…
-
Editors cannot overwrite cells with formulas
Hi there, In a sheet I've few cells that have formulas, columns were those cells are aren't lock, however the users cannot overwrite the formulas, any idea why it may happen? The idea was to create formulas as a guidance but editors should be able to overwrite them, in this case isn't happening, they cannot enter values in…
-
Sum a range greater than >25000 based on the status of a check box
Help! I cannot figure out a formula for SUMIF or SUMIFS to add a range of numbers in a column that are greater than 25,000 based on a checkbox. =SUMIFS({Content Limit - NB}, >25000, {Reporting - NB}, 1) <-- why doesn't this work. hehe I keep getting #invalid operation. This formula works =SUMIF({Content Limit - NB},…
-
Formula in % Allocation Column?
I am certain this has been asked either currently or in the past, but is the capability to include a formula in the % Allocation column on the product roadmap? Right now, I have a column entitled "% Alloc Calc" next to the "% Allocation" column to calculate the % Allocation for my users. The users must ensure that both…
-
Using Emojis in Smartsheets
We want to use icons that relate to our work. I have an IF formula that includes emojis. =IF(Classification4 = "BAGS", "🎒", IF(Classification4 = "SOCKS", "🧦", IF(Classification4 = "GLOVES" = "🧤", IF(Classification4 = "BALLS", "⚽️", IF(Classification4 = "PROTECTIVE", "🛡", ""))))) For some reason, the "BAGS"🎒and "SOCKS" 🧦…
-
Need a formula for counting information based on date
Hello, I need a formula that can help me calculate the sum within a column based on date. Not sure if this can be achieved. We are updating information on a weekly basis and I have different rows for the same date. I need a formula to give me the sum based on the date. For example, on 1/17 I will have 6 rows with data that…
-
Sheet Summary Formula for Due Dates
Hello, I have two separate column Status and Due Date and I'm looking to create a formula on the sheet summary for the amount of items that are due today and past due. Is there a way to create one?
-
Formula to average a range in another sheet corresponding to cells that contain parts of text
I can't seem to beat this formula. I've tried COUNTIF, COLLECT, CONTAINS, and when I'm not getting an error I'm getting 0. I want to see the average of successful deliveries below for all Up to Date emails in Q1. In the sheet I'm working with I'm trying to say: If any cell in the Month/Year/Email column contains the words…
