-
Issue with IF AND formula
=IF(AND([Engagement Phase]@row = "COMPLETED", [Production Status]@row = "Production Ineligible"), 0, 1) The formula is not working completely. I think i need to add an additional clause/check. Engagement Phase dropdown column with "In progress", "On-hold", "completed" etc statuses. Production status column with values "In…
-
Automated formula for dates
Hi All, We have internal learning modules, and once completed you are issued a 'badge'. I want to create a report that will tell me each month how many badges were issued of each badge for that month and then the total for the month. i.e. Dec 2021 10 IT badges, 5 HSE, 6 Ops badges = 21 for December I have created a new…
-
Formula to drive checkbox if today is between the start and end dates
Hi All! I've looked at prior posts on this topic and have followed the formula advice, but I continue to get an error. Here is the formula I am using. =IF(AND(TODAY() <= [Reporting End Date]@row, TODAY() >= [Reporting Start Date]@row, "Checkbox", "")) I'm getting an Incorrect Argument error. Help. Thanks!
-
Help with Question on formula - getting unparsable - eyes are crossed
Hi, I took my formula which worked in excel and have tried to reproduce it in smartsheet and I am getting an unparsable, I am going cross-eyed trying to figure out what I am doing wrong. Here is the formula if someone can help me figure it out. thank you - Amy =IF(AND(ISTEXT(ExpirationDate1), Datefirst1 = "", Datesecond1 =…
-
Strategic Meetings Management Template
Greetings Smartsheet Community and Well Wishes to All! I'm looking for a template or guidance building a sheet that captures and tracks my company's offsite events on an annual basis (e.g., logistics, spend, metrics). The objective is to gain greater visibility into our events' activity and determine ROI similar to a…
-
Which app is best to assist in pulling data from one sheet (autofill)?
Hi, Community, I am setting up an attendance sheet and would like to be able to start typing a name of one of my members and have it prefill from my control membership sheet (name), and then pull in the person's Title, Member Persona(s) and Track(s). Is that something best done with a formula, or Dynamic View, or Data…
-
Health status in a project plan
Hi, I am wondering if anybody can help me with setting up a formula that flags Red, Yellow, Green, Grey based on Status and Due Date. If the status is complete, grey. If the status is not complete and the due date is more than 5 working dates days in the past , then yellow. If the status is not complete and the due date is…
-
CountIF to look for a partial piece of text
Hi all, I'm looking to use Count IF to look for piece of a text from a different sheet. I've tried the following variations with no luck: =COUNTIFS({QA WORKLOAD Date}, "BACKLOG", {QA WORKLOAD Com/CT}, "COM", {QA WORKLOAD WO ST}, "99", {QA WORKLOAD Description}, CONTAINS("SUB", @cell})) =COUNTIFS({QA WORKLOAD Date},…
-
Today Forumula Question
So I'm still learning formula's. I'm trying to create a formula in my sheet summary. I'm looking for a count of end dates thats within the next 4 days. from today. Here is my formula: =COUNTIF([End Date]:[End Date], >TODAY(4))
-
How to Pre-Populate a field in a form with a unique ID?
Hello Community, I am asking for your help today figuring out a challenge I am currently facing. We are trying to pre-populate the "Work Order ID" field in the form because it is often overlooked or entered incorrectly. We have been trying to figure it out but it is hard because you cannot have a column formula field in…
