-
Multiple IF condition is not working
I want to apply a formula so that when a value is greater then 9, it should mark the initiative as high priority, 6-9 be marked as medium priority and less then 6 is low priority. The most letest formula i wrote is: =IF([Priority Score Final]@row > 9,"high",IF([Priority Score Final]@row >6,"medium",IF([Priority Score…
-
Flag first occurrence as “Unique” and others as “Duplicate” by person + date
Hi Community, I’m working in a sheet with a bunch of historical data that has these key columns: [Personnel Name] (staff contacts) Date (date) [Duplicate Check] (text, where I want the formula to live) What I’d like to do is: Treat each combination of [Personnel Name] + Date as a group. For each person+date group, mark…
-
Managing dates
Hi SS Community! I have a feeling this maybe a simple answer, but I have looked on the internet with no resolve: I have "Project Plans" for each one of my projects. I use dependency settings. For dates I have Start Date, Due Date, ESTIMATED NUMBER OF DAYS TO COMPLETE, Estimated Completion Date and Complete Date (Record)…
-
Move attachments between sheets
Is there any way to move attachments between sheets without the clunky "Move a Row" or "Copy a Row" automation?
-
Function() or @argument for "currently logged in user" for use in Sheet formulas
I would like there to be a function() or @argument (e.g., User() or @user, perhaps?) that I could use in Sheet formulas that would evaluate to the "currently logged in user". This would enable more flexible Filters in Sheets that could be supported by Helper columns for evaluating logic against multiple multi-select Person…
-
Adding date ranges to column headers
Hello Smartsheet Community, I saw something at the conference in November and I'm having a hard time remembering what it was called so that I can figure out how to use it, I think it was a "series". Here's my problem: I have several sheets that I am using to create "block based" schedules, each block is defined by dates,…
-
sum of parent rows only, below parent and child rows
Itemized budget rows, which are the sum of child rows. All data entered in child rows and totaled in the parent row. At bottom of page, I want to total the parent rows only. Any way to do this? Screen grab attached.
-
Month Function Sorting in Report
Hello! I have a sheet that captures items and their start/end dates in a date format. I am trying to create a report that will group the items by the Month that the item is taking place in chronological order (Ex: All items with the target end date in January would be grouped under "January", followed by all items with the…
-
Generate Formula that identifies duplicate entries and notates most recent entry
I'm trying to create a formula that searches through the serial numbers in a column and if there are duplicates of a serial number, it puts a "yes" or check for whatever duplicate was entered most recently. I have a time/date of entry column, and I also have a duplicate entry column that counts up each time it identifies a…
-
Rolling budget/spend tracker
I have a bit of quandary with a recurring task, wherein I am tracking weekly budget allocations and tracking what is NOT spent. Currently, I have a basic sheet where my contractors/vendors upload a patient record, which is just a sign-in sheet, and I manually count the hours used. Each of these sheets represents a maximum…