-
Lookup or Data Mesh for values based on 2 criteria
I have a sheet that I'd like for it to enter a value based on 2 criteria, Site and Job. John Doe gets hired for Job 3 at Site 8 ($131,040). Is there a formula for Smartsheet to enter the value based on column and row data? Or is there a way to set up Data Mesh to lookup this way?
-
Duplicate reference data from another sheet
Hello Community, I have a sheet that is daily populated by a field engineer which is linked and referenced with a formula for a weekly report for the Ops manager. The Ops manager's report is being used in presenting a dashboard for top executives on a weekly basis. These reports have to be done each week while maintaining…
-
Update Cell to show current trend arrow for current month
Hey Community! I have not been able to find a viable solution to what I am trying to create. I have a repository sheet that keeps track of current data. In this sheet, I show trend arrows that show "Sideways," "Up," and "Down" depending on the data entered. Now I'm attempting to figure out how to display this trend arrow…
-
Formula to fill in the information in another column
I have the RPs, OLH Assignments and System Roles added as a dropdown list. I am trying to find a formula that will add the OLH Assignment and System Role based on what is checked in the Associated RPs column. Ex: If "Clinical Manager" is added to the Associated RPs column, then "Clinical Supervisor Home Health Curriculum;…
-
Formula: CountIf
Here's the situation: I have seperate source sheets for each function (Human Resources, IT, Finance, etc.) that syncs with data mesh (copy data) to a master sheet. However, sometimes rows get deleted from the source function sheets and then our master sheet still has the deleted row on it. I'm trying to have a checkbox…
-
Help with Weeknumber function that takes into consideration years.
I would like to do a if Statement I have a column called "Date" w/ a Date I have a column called "Health" which is a color (red,yellow) I would like to do a formula in my Health column If "Date" is Next Week then "Health" = Yellow If "Date" is Last Week then "Health" = Red Requirements -I would like to not count by days..…
-
Formula required to show availability of tools
I have been using Smartsheet for a few years now but I am stumped on this one: I have a list of tools in a drop down e.g. Drone, Shovel, Measuring Tape. Staff request a tool via a SS form. I want the person responsible for managing the tools to be able to see if the requested tool is available straight away when a new…
-
Text before Formula
Hi Everyone, Please can I use smartsheet to achieve inserting a text before a formula just as can be done in excel ="The Total is"&Sum(E4:G18) and the answer the reads The Total is 19 Thanks
-
Need a Formula to Show if Current Month & Year (in a checkbox)
=IFERROR(IF(AND(MONTH(TODAY) - MONTH(Date@row) = 0, (YEAR(TODAY) - YEAR(Date@row) = 0)), 1, 0)) Hi I want to check the "Current Month & Year" column from the Date column if true, so I can roll reports and data for next year. Not sure if my attempt is close or not!! Thanks in advance.
-
Help needed for a formulae that changes the status symbol when a specific sale stage is >30days
Further information: I'd appreciate some support as I cannot work out the formulae to give the following: Stage 1 - 2 is Blue when <30days old and Red when <30days old Stage 3 - 5 is Green when <30days old and RED when old Note: Sales Stage Change Date is a automatically populated when Sale Stage value changes.
