Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Predecessors and Formula's Error when I delete rows
I have a master sheet that has tasks for all types of projects and depending on the customer we sign, I will go through and delete the rows I no longer need. The issue is that my RYG (error: #BLOCKED) and Predecessors (error: #REF) error when I do this which means I then need to go back and correct them manually Is there…
Highlight Row if column is "true" and date is 7 days greater than....
Access 2007... I am creating a report tracking spreadsheet. Basically consists of a column of report numbers (column A) and then different locations that report may be sent to with a checkbox column... if checked, the column next to it displays date it was checked. I would like to highlight a row if the report has not been…
Resources and Duration
I would like to make the “Duration” column dependant on the hours needed and the team assigned to develop a task; something like “Hours (quoted) / Team (number of people)= Duration”. Is that possible? How can I do it? Thank you for your guidance.
Export to letter formatted document
Has anyone tried building a sheet that would have a presentation level, letter format when exported? I'm looking to build proposals within Smartsheet, then I could cell link that final/approved fee into my project tracking sheets for cost comparison etc. In Excel you would typically do this via cell merging etc, but that's…
Using pointers for relative addressing
Greetings: Is this possible in smartsheet? (I have searched through the list of functions, a video on the use of cells, and the community but have not located any info on this.) Would like a formula to look at the current row's dependency and treat that value as a pointer to reference the value on another column in the row…
Auto Formatting with New Row Entry (via Webform)
Scenerio: Row 1 and Row 2 have a Blue Background for all 6 Columns. I created a webform to add above these 2 rows for all 6 columns. When I submit the webform, the added row does not receive the lower background on it. This use to work, and now for some reason it is not. Let me know if anyone has any fix, thanks!
Automate RYG balls
Hi, I am just getting started with formulas. I'd like to automate the colors of my RYG symbols based on the dropdown options in another column (see screenshot). If Status column is Event Scheduled - Green If Status column is Event Declined - Red If Status column is anything else - Yellow. Can you tell me how I would write…
Auto row numbering not functioning problem
I created a new task list and set the auto row numbering in my first column, and set to document my tasks. Saved the sheet and then moved on to other things. The row numbering at this time is set correctly to 1 - 10 type of thing. I then went and added additional rows at the bottom and the dates and then wanted to sort the…
sumif date is today to end of month
Trying to write a formula that doesn't need manual updating that basically sums a total amount for file that have a closing date from today to the end of the month. Seems like it should be fairly straight forward but I cant get it to work. The sheet has parent rows but i want to include all rows in all parent rows in the…
Shortcut
Does anyone know of a way to put a shortcut on your desktop to a specific smartsheet?
