-
Since Smartsheet Gov has no sheet summary, where do I put formulas?
I have a sheet I want to move over to the gov version, and when I went to do that I noticed there is no sheet summary. My sheet has hundreds of formulas and it would be useless with out them. Any suggestions on where to put them? Do I make another column called sheet summary?
-
Enhancement Request: access values stored in cell history
Hi guys, my idea here is to use the stored information in a cell value. Let's say that the first time this cell was changed is important to me and I want to store this value in a different column in my sheet. I would then use a formula to get this stored information, for example: =GETCELLHISTORY([info], [position]) info:…
-
anyway to create formula for matching current user to cell contact list value
I've tried multiple things, even making them select a dropdown on the top row so the "modified by" for that row captures their name then using another column with contact list property with the formula "=[modified by]@row" for the remaining rows. But even this fails since in the "standard" contact list dropdown my name…
-
Automatic Predecessor Adjustment
Hey All! I have a question about how to have predecessors or just tasks in a schedule to automatically update when they are moved in the schedule. I am trying to create a production schedule for our Sheet Metal shop and it is created with the fabrication packages released from the Eng Dept. Sometimes the schedule needs to…
-
Can I Import a Large Excel Sheet with Embedded Formulas into Smartsheet?
I am needing to import an excel sheet into Smartsheet with 10+ tabs at least 16383 columns. There are imbedded formulas referencing different sheets in the excel. Is there a way to go about this rather than importing one of the tabs at a time, and manually rewriting a lot of the formulas?
-
Formula to return a checkbox on Sheet B, if a % column in Sheet A = 100 + move rows
Hello there, I have 2 sheets: Sheet A - Base File, where i have % Column where i input the current numbers. Sheet B - Transfer to File, where i need to add a checkbox to a row, if the % Column in Sheet A is 100 %. I have managed to make the reference where: =IF({Base File Range 5} = 1, 1, 0). BASE FILE TRANSFER TO FILE My…
-
Calculating a review date based on both the hire date and last date of review
So I've burned up about 6 weekends working on this, and have asked a few peripheral questions on it, but never just asked the whole thing. I met with a Smartsheet pro and he suggested I bring this to the community. I would really appreciate some help on this. I need a formula that will calculate the next review date…
-
Is there a way to create a flow chart that leads to a result depending on how the user answers?
Hi! I currently work in a manufacturing plant where in order to quote a new project we need to create a chart showing the number of people and the line speed required to run the project. I am currently the only one on my team that has the knowledge to make these, but would love to create a flow chart type system where…
-
Formula to display one date in a range with 3 criteria
Hello everyone, Can you please help me with a formula? I have three columns: 'Start date' , 'Dose', 'Site'. I would like to consider multiple criteria: 1) the start date is in the future 2) the value in the 'Dose' column is 'drug' and 3) the Site is '01'. Based on these criteria there should be a list of dates, but I would…
-
Join formula started adding a leading zero on text from certain columns
I created this formula, and it worked great the first two times it was used. The third time, it added a leading 0, which is NOT present in the [Circulation Requirement Details 3] column. I did further testing triggering the function using [Circulation Requirement Details 4] and [Circulation Requirement Details 5], and 0 is…