-
Conditional Formatting to add days to date based on risk category
Please help. I am trying to work with two columns: A Risk Category column which consists of High, Medium, and Low categories;. And a Committed Closure Date column which, depending on the risk category, is the date by which the gaps must be closed. Here is what I have which has not worked. The columns are already of the…
-
Include Previous Update Request Response in Current Update Request
Hi! This is my first question asked on the Smartsheet Community and I'm hoping someone can help me, because this would greatly help our users. My boss and I run the HR PMO for our company, and we use Smartsheet to collect project updates for all active projects in the HR portfolio. Updates are requested from what we call…
-
Auto-populating A Form Field
Hello, I currently have a form that asks users to select a product from a dropdown list. Is it possible to auto-populate the email address field so when a product is selected, the email address associated with that product automatically pops-up?
-
Automated email not working
Hello! I'm know that this is going to end up being something easy but I can't see to make this work. I have a sheet that tallies ratings and gives a % of that rating towards the target. The column is setup as a text/number and has the number as a %. Once a week, I'd like an email to go out that lists any of the different…
-
IF(ISDATES and Blanks)
=IF(ISDATE([A]@row), IF([A]@row < TODAY(), "Expired", "Valid"), IF(ISDATE([B]@row), IF([B]@row < TODAY(), "Expired", "Valid"), IF(ISDATE([C]@row, "Valid", IF(ISDATE([D]@row, IF([D]@row < TODAY(), "LATE", "Out for Quote"))))))) I have the following statement above. I'm trying to have it say "Late" if Column C has no date…
-
Need a way to update a field from one sheet to another
Any suggestions on how to do this? Sheet A has a field, the cell gets copied to Sheet B. When a cell changes in Sheet B, I would like it to automatically update that same field name in Sheet A without having to manually link fields.
-
Editing a group
I am using Groups with Control Centre; I am the admin and my backup admin says he can't edit a group that he isn't the owner of. Is that normal? He says he can create a group and make edits.
-
Is it possible to export only newly added rows in Smartsheet to Excel?
I am working on a group project using Smartsheet. One person's job is to add 70 rows each week. The next person exports the data to an Excel spreadsheet. They want to be able to export only the new rows entered, not the entire dataset. Is there a way to only export certain or newly added rows? Thanks!!
-
Is it possible to export only the newest entries of a Smartsheet to Excel?
I am working on a group project using Smartsheet. One person's job is to add 70 rows each week. The next person exports the data to an Excel spreadsheet. They want to be able to export only the new rows entered, not the entire dataset. Is there a way to only export certain or newly added rows? Thanks!!
-
INDEX/MATCH on Blank and No Matches
Hi all, Working on using Index/Match to pull through a Single Select Dropdown (Y or N) if the corresponding PO exists. As standard, I'm using IFERROR to populate to ensure if there are errors it shows a more user friendly message. =IFERROR(INDEX({QC sheet Range 1}, MATCH([Product PO#]@row, {QC sheet PO Number}, 0), "Task…
