-
Date column formula to start on a specific date and continue on after that.
Hello, So I have a helper sheet that tracks total number of entries for each month in each year. Right now I have a formula set up that checks the date above, and depending on if the current month is past that month, it will automatically fill in a new line with the current month (Due to date formatting, I have it set that…
-
IF then statement
Hi, Fairly new to smartsheet, I am looking to do the following: If 'Drop Down A' is set to 'No', then set 'Date Column B' = 'Date Column A + 30' If 'Drop Down A' is set to 'No', then set 'Date Column D' = 'Date Column A + 14' If 'Drop Down A' is set to 'No', then set 'Date Column E' = 'Date Column A + 7' Appreciate the…
-
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.
