-
Displaying a date in a non-date column
I am trying to display the earliest date in the "Start" column and the latest date in the "Finish" column, thereby getting the start and end dates of the whole project. I can get these, and display them in a third column formatted as a "date" column. Now, I want to include this text (the date) in a forth column formatted…
-
Working with Time Values in Cells
Hi all, perhaps someone can help me with a workaround. I have a sheet that captures time values in a column. As far as I know, Smartsheet doesn't recognize time or have any formulas more granular than "Date" formulas. My question is, does anyone know a way to convert time values into numeric values? For example, if the…
-
Automate % dependant if cell is blank or has a date
Hi, i am looking for some help please. I have a % complete column that i want to automate to 100% if a date in another column has a date in, but also return 0% if the date column is blank. I feel this should be easy but am struggling and would appreciate any help. Thank you as always Dave
-
Formula irregularity
Fairly new to Smartsheet, although I know my way around an Excel spreadsheet. I am trying to create a count of how many reports are submitted per hour on each given day. The reports come in via a Web Form, into the Taxi Rank Data sheet. I have created the following Sheet (see attached jpg) with the following formula,…
-
Formula to automatically check a box when a certain cell is populated
I am trying to get a column to automatically check a box when certain cells are populated in the same row. This is linked to an update request situation. Basically, when an update request is fulfilled, OR when a certain cell has information in it due to the update request being filled, I would like a certain box to be…
-
Two different triggers for one check box
Hello, I find this community very helpful in the search function, but I haven't participated much with my own questions. I'm hoping you can help. I have one check box that I would like to be triggered in two different situations "this OR that" kind of question. I have it programmed for one parameter, but I don't know how…
-
OR function to check a box
I am trying to get one box to check under one or another conditions. 1. when a certain cell has any text 2. When another certain box is checked The function I came up with follows, but it doesn't seem to work. There might be one small tweak I need to make, but I am still new to making formulas. Thanks for your help!…
-
Data from one sheet form to populate another
I have created a smartsheet that contains a form for my team to fill out. Once this form is filled out I would like that data to go to the main sheet that is viewable by my team and then populate another sheet that is viewable to the managers only. Is there a way to have that data when added to sheet one (main sheet) via…
-
IF COLLECT / MATCH COLLECT / INDEX COLLECT / VLOOKUP ?
Dear Community, I am trying to have an automatic filling of the column [Budget Max] while changing the column [Level] based on 2 other columns references: [Level attribution] and [Max Budget Range] with matching ROWS. If [Level]value = [Level attribution]value return [Max Budget Range]value of the same ROW of [Level…
-
Using SUMIFS, on a column that displays a $, based of a formula
I am looking at tieing 2 sheets together. My data sheet has a Column A, that is a check mark or not. Column B has a formula of "=IF([Column A]1 = 1, "$2"); therefore, it displays "$2" Column C has a month number, "01" I want a sumifs to sum all column B. But it display $0, and am assuming its because the formula in column…
