-
How to set up move row automation with formulas
I currently have a formula in place to "star" a row on sheet A when a unique identifier # from sheet A is added to sheet B. Then, I would like to move the row from sheet A to sheet C after the "star" is highlighted. I read the statement below in the smartsheet Automation article: "Actions that will automatically modify the…
-
Is there a Column Formula I can use to always assign tasks to myself?
I'm trying to sync up my personal task list along with client task lists to all flow into one report, which means I need to assign everything in my personal task list to me in an Owner column. Is there a way I can automate that with a Column Formula?
-
Automation
I am maintaining a tracker with training for the whole year for our team. I was planning on using the workflow to notify employees of an upcoming course. I have the email address in a column but I am unable to select email notification. Can someone please let me know how do I fix this? Thanks in advance.
-
Index, Match, Max, Collect
I am trying to use the following formula to identify the name of the last Manager in Training (MIT) to graduate their training program with a certain Mentor, but wherever there are instances of MITs having the same graduation date, the formula is returning the wrong MIT for the given Mentor, and I cannot figure out why.…
-
Formula - INDEX/MATCH
UPDATE: =IFERROR(INDEX({Issues/Incidents Tracker Range 2}, MATCH([Project # / Request #]@row, {Issues/Incidents Tracker Range 3}, 0)), " ") I forgot about IFERROR I had a quick question about a formula. I am attempting to pull in data to reference another sheet. In my formula, I have attempted to add in “” and false (in…
-
COUNTIF combined with MONTH
Hi there, I am trying to combined a COUNTIF with a MONTH=12. Trying to count whenever the date is in December. I got this formula set up, but it comes back as O and I know I have 12. =COUNTIFS({DAX Engagement Tracking Project Number}, <>" ", {DAX Ambient Inventory Actual Install Date}, MONTH(@cell) = 12, {DAX Ambient…
-
Counting the value from one column only if it is in the future
Hi All, I have 2 columns, one with Fuel systems, and another with the dates they have or will be delivered. Looking at the snap shot below, what formula would I use to only count the entries of the fuel system column that contain "AGILITY" and that have a Del Date in the future? Thanks
-
Graph of Summary Numbers
Is it possible to create a graph of the Summary Totals in a report? If not, what is the most efficient way to create a report where I can show the total of the last 7 days for 5 columns of data? It will have to be automatically updated in the graph each day. I'd rather have a graph, but I also tried to add the report to my…
-
Counting dates on the current week number and year
Hi, I am trying to count the number of New Patients (by Case Type) that visit on the current week and year. The below formula is working but for some reason I will get the error message "INCORRECT ARGUMENT" until I refresh or save. Once I do that it will calculate the correct count. =COUNTIFS({Date of Visit},…
-
Auto-Number/System field Created (Date) changes back to "Date" field
I have an Auto-Number/System field called "Date Submitted" as Created (Date). This is used on the manual form (which we are phasing out) and also to capture any new rows that come in from Salesforce sync. For some crazy reason it keeps changing column properties to Date. In which case two things break: Anything that syncs…