-
Record changes to only 1 cell
In a sheet where another user and I download files and mark them in different stages (proofed, processed, uploaded), is there a way to record who last modified a cell rather than a whole row? I'd like to have a cell automatically record who changed which phase. I know that I'm able to right-click a cell to see its history,…
-
Smartsheet forms with text formatting
Hello. Is there an option to allow text formatting/editing (such as bullet points, bolding, italics, hyperlinks) in a form linked to a smartsheet? I have a column in a sheet named description, which I would like users to give a comprehensive description using the Form. Ideally similar to the formatting options I see within…
-
Change symbol based on date
Good morning Everyone, I have been having some issues configuring a formula in smartsheets. Currently the only two columns that matter are named "Status" and "Last Run". What I'm trying to write is a function in which... Green appears if the last run date is within 30 days Yellow appears if last run is within 31-60 days…
-
Formula that will allow a date in text format to be captured in a date format
I have a Date getting imported as 08JUN2021 (2charDay+3charMonth+4charYear) and I need to switch it to a Date format that will allow integration in other formulas and logic flows. So far I have tried these 2 formulas without success: =DATE(VALUE(RIGHT([WES Evaluable Report Date]@row, 4)), VALUE(VLOOKUP(MID([WES Evaluable…
-
If with And Formula help
Hello, I'm trying to write an If with And formula to flag if my micro/QC column contains a specific phrase, and my Date Submitted column is past its date by 12 days. Here's what I have =IF(AND([Date Submitted]@row - TODAY() >= 12, [Micro/QC?]@row = "QC", 1, 0)) I'm getting incorrect argument set error and can't figure out…
-
Button to add text to pictures is missing in Android app
Hi, According to the following help article there should be a button to add text to pictures when uploading pictures with the Android app. This button is missing in the app on my phone and on my tablet. I updated both devices to Version 9.3.0 Build 323. Is it possible to solve this? Screenshot from the article: Screenshot…
-
Can you block users from adding new lines after a certain number?
We are using a sheet to track candidates for a position. We need X number of candidates to Y positions. We're using a formatting trick to show when the target number has been exceeded but it would be nice to be able to limit the number. Users would still need to edit the existing candidates.
-
Indirect style look up from another sheet
Hello, I am trying to access data from another sheet using a reference to another column within the row using a sum formula usually in excel I would create a =indirect() reference, how could I replicate something like that within smartsheet.
-
Copying rows to the top of a sheet (Automation)
Hi Everyone, This question was asked before but I have not found an answer. So asking again to see if there is any new development which I have missed. I have set up an automation to copy rows from each project sheet to a master sheet (based on some trigger). The row for the first project was copied arbitrarily in the…
-
Autocomplete data entry like Excel
I simply want to have Smartsheet autocomplete my data as I enter it in a cell as Excel does. Is there a way to turn this on?
