-
If you delete a reference, can you get it back?
Hi, I am working on metrics and had a reference to a sheet that got deleted by mistake. I thought I could delete the one-column reference without deleting all column references. Not sure what happened. I was able to drag the formula and see the correct data in the onboarding column, but the reference link is not showing on…
-
Attachments - Retention Period
I am using smartsheet function to attach documents to my rows representing additional information associated with a task. Is there a retention period that is associated with adding files? For instance, if I need to open the file in 5 years, will it still exist? Will it exist in perpetuity?
-
Search and Replace in formulas
When importing from Excel I need to fix some of the formulas. This would be easy if I could use a search and replace within all the formulas on the sheet in one go as you can in Excel. Does anyone know if there is a way to do this in Smartsheets?
-
Update Request and include date validation
I have the following sheet: User 1 will enter the Client Name and Historical Data Load Date via a form. This triggers an update request to User 2 to provide the FHIR Ball Catchup Set Date. This date must be BEFORE the Historical Data Load Date. I have the sheet set to flag the row if the FHIR date is AFTER the Data Load…
-
Help w/adding NETWORKDAY - formula not working
Hi team - I have an automated date column called 0. DDO Assigned (actual) that records a date from a status change in another column. I want to add 4 working days to that date as a "bench mark" in the 1. Pending 3PRM Refresh/Aggregate IRQ (BM) column. I tried using the following formula and, while it does not error out, it…
-
Which formula do I use?
I used the following formula =COUNTIFS({Imp Group},Label@row, [{IT Sizing}, [IT Sizing]1) for the table data below. I keep getting unparseable. What am I doing wrong? Source Column Title for Rows Day 0, Day 1 & Day 2 is "Imp Group". Source Column for title is "IT Sizing"
-
Changing value in cell
Hi All, I am new to Smartsheet so any help is appreciated. Currently trying to use multiple sheets/forms to record inventory by scanning a basic barcode. I have setup form entries to be duplicated in another sheet but the value of the barcode in numbers (ie: 407621031) needs to be recorded as the item name. For example, I…
-
VLOOKUP formula to copy values from one sheet to another
Hey Guys, I Have a sheet name "Holiday", and I want to copy the cols "Country", "Start Date" and "End Date" from this sheet to another (empty) sheet called "Holidays Israel", BUT only the rows that thier country is Israel. I tried VLOOKUP (this is the formula I used: =VLOOKUP("Israel", {Holidays Range 3}, 5) but when I…
-
Remove Timestamp from Merge cells
I have merged 3 columns (and it worked) however two of the columns are start and end date columns and when it is merged it brings in the time -- which I do not want. Any ideas? The formula I am using for Week-ending column is =[Week #]@row + "-" + " " + Start@row + "-" + Finish@row What I want to see in the Week-ending…
-
Formula to evaluatdata from last row of a sheet of data
Hi Dears, I have a form that completes the data of per date with the status of the asset per column, therefore I'm looking to using countif the different status, but I need that the formula evaluates the last row which should be the lastest info updated based on the latest date. I'm trying to use INDEX or MAX but I didn't…
