-
Month from Week Number
The data source I have is only providing WeekNumber of a transaction, e.g. 1 - 52. Is there a way to convert that week number into the respective month number, 1 - 12? I can think of a painful nested if formula or an equally painful reference table as solutions. But can anyone think of an easier formula?
-
Formula Assistance
Good Morning Community, I was hoping that someone could validate the below IFAND formula as I am getting an error which I cant resolve: =IF(Status@row = "Green", "On-track"), ifand(Status@row="Yellow", "At-risk"), ifand (Status@row="Red", "Not on track"), if(Status@row="blue", "complete")))
-
COUNTIF Empty returns 10 extra lines
New to Smartsheet - Built a primary sheet, populated by form. 👍️ Now building a Metrics sheet to gather Status row counts to build a Database w/metric widgets. For some reason 10 extra rows are being added to my primary sheet when I use the COUNTIF formula on the Metrics sheet that references the Status column in my…
-
Formula for Status
Hello, I am trying to create a formula to automate the 'status' row in my project grid in SmartSheet. Here is what I am looking for: Actual start date = Blank, show "Not Started" If Actual Start Date = is a date and Actual end date = Blank, show "In Progress" If Actual start date = blank and projected start date > today OR…
-
Conditional Formatting
I have never had this issue but currently I have conditional formatting set to make a cell 'red' if the due date is in the past. The date is calculated based on a formula from other cells but this is a date column. The conditional formatting will not work. I have several dates in the past and none are following the…
-
Report Grouping Work Around
I have a list of SOPs and their supporting documents (Forms, Logs etc). As you can see in the Excel example, we have the SOPs in Green and the supported docs below. Some, like the SOP Training/Retraining Record, are used for multiple SOPs. I tried: Using Gantt functions, added a Predecessor Column but I couldn't run a…
-
Formula returning 0
Hi Can anyone help me with this formula? Should be really simple, but i am having an off day it seems! The formula is looking for any elitebook g3 devices that are in northampton, but gives me the result of 0 instead of the correct number? Any ideas?
-
Automatically Track Inventory Usage
I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage based on information input into a separate smartsheet form? I have two sheets: one is the…
-
Formula for 2 columns - checkbox and a date range
Hi there - newbie here. Looking for help with a formula. I am trying to drive a metric which shows the percentage of activities on 'THD Brands' in the past week. The 'THD Brand' column is a checkbox, so essentially I need to count anything that is ticked in this column, and also the 'Last met?' column has a date within the…
-
IF AND INDEX MATCH to pull the correct row based on criteria
Hello all, I am struggling to come up with the correct formula to pull the right information between master sheet and personal tracker and I wondered if you can help. My logic for creating the formulas is not the very best. What I'm essentially trying to do is pull the right start/end date and budgeted hours from the…