-
Systems and Services subscription renewal dates
I have a sheet which tracks the various systems we use and their monthly & annual subscription charges. We'd like to have SS tell us when a renewal date is approaching, particularly with the annual charges at first, but then have that date push out to one year (or month if it's monthly). A notification email would then get…
-
Creating a formula that takes the total average of a row but excludes certain entries
I need to create a formula that take the total average of the row but doesnt include entries that are "N/A" "YES" or "NO" in the count. At present when ever those are entered the formula im using counts as "0" which greatly decreases the total percentage
-
HELP WITH INDEX/MATCH ACROSS MULTIPLE COLUMNS WITH CRITERIA
Looking for formula help to accomplish the example below:
-
Using IF, Index, Match
Hello, I need a formula that will create the response "Green" if the Agency name matches the "Live Agencies" sheet to my current sheet, as well as have any of the following services (485 Review, OASIS/485 Review (No coding), or Non-OASIS 485 Review) in the "Coding Services" column of the "Live Agencies" sheet and create…
-
Dynamic formula to update a cell with a URL & Display Text
When I create a URL in a cell, it consists of the URL, and Display Text. How do I write a formula to, say, add the value from the autonumber field onto the end of the URL, and then display the autonumber field text as the Display Text?
-
Nonparseable error using IFError
this formula keeps an error. =IFERROR(INDEX(DISTINCT({Project Info PM}), ROW()), "")
-
Formula for Month in words
Hi everyone seeking for a help please I'm making a helper column formula for month I want the result as Month - day- Year (October 28, 2025) but it seems my formula doesn't work is there any way to have this formula or result as (October 28, 2025) =IF(ISDATE([Refund Deadline]@row ), MONTHNAME(MONTH([Refund Deadline]@row ))…
-
Referencing a sheet that has non-working days
Hello. I need help please. I am working on a Smarthsheet schedule where I need to define the calendar (ie exclude public holidays and our annual construction builders break) without enabling dependencies because that messed up my sheet previously. I have a separate sheet that has a list of non working days. My formula is a…
-
Mastersheet Linking errors after adding column #unparseable #incorrect argument #blocking
I added a new column to a target sheet. Broke my mastersheet, resulted in #incorrect argument error in all columns with the exception of Primary Column. Went thru checking all column types basic trouble shooting of links couldn't resolve it. I made a new Mastersheet opened "table view", use formula cell linking. Created 4…
-
How to Sum Across Multiple Sheets?
Hi, I have six sheets with an identical setup. I want to be able to summarize how much Effort each person has been assigned for all the sheets. For example, Bugs Bunny may have 12 hours assigned in Sheet 1, 4 hours in Sheet 3, and 24 in Sheet 5 for a grand total of 40. I want to be able to summarize total Effort for each…