-
An error has occurred in the application. Please log out and log back into the application before c
Hi There We have call Smart sheet a number of time, left about 5 messages and still waiting on a reply I have also emailed as seen below. Regards Jacqueline Niemand Hi there, We Emailed over 10 hours ago and it’s still coming up with the following error we have loss a whole day with a number of staff not being able to done…
-
How to Setup Formulas to Automatically Link & Pull Data from Other Sheets
I'd like to try and figure out how to most effectively and efficiently connect 2 separate smartsheets together, preferably through some sort of smart formula/code. I don't think doing a manual "cell linking" from a cell in one sheet to the next would be very smart or efficient for what I'm trying to do here. I have both a…
-
Stars Value
How can I convert the 1-5 Stars Symbol into a number using one formula. I have one column Stars and the one with number should be Rating. I also don't know why they chose to have it convert in Excel to Empty, One, Two, Three, Four, Five. Why not numbers? Thanks for any help.
-
Assistance rolling up data to a master sheet
Hello, I’m trying to create a roll up for multiple resources across multiple sheets. I would like to have data roll up like how it looks in the Resource Allocation, but I’d like to view allocations in hours rather than percentages. I've attached an example of a project schedule in SmartSheet that we use. I thought that it…
-
Enhancement Request: Show and allow edit of Working Days when Dependencies are disabled
When working days are set (either by SysAdmin for new sheets or directly in the sheet) and Dependencies are disabled, the dialog implies they do not impact the sheet. But they do. I posted about this today: http://ronin-global.com/2017/06/23/smartsheet-using-working-days-without-dependencies/ Since they impact the sheet,…
-
Does Smartsheet support SUM COUNTIFS formulas?
Howdy Smartsheet Community, I've written a =SUM(COUNTIFS) formula to count the number of specific text entries in one range that meet specific criteria. Based on the in-line formula help and online SUM COUNTIFS research I've done, it appears that my formula is correct but keeps returning #UNPARSEABLE. Has anyone…
-
Date Created System Column not updating if NOT using webform
I am modifying the "Help Desk Ticket Tracker & Form" template. I don't want to double-enter the date, so I deleted the 'date' column and am using the 'Created (date)' system-generated column. When I use the webform, it will fill in the date created. But if I add a line directly in the smartsheet, it leaves the Created date…
-
Linked cell skewing formula result
I am trying to write a formula that checks for 4 criteria; a. That the result in cell [Transition]38 = "Transition" b. That cell [NPS %]38 is not blank c. That cell [BG KPI]38 is not blank d. That cell [LE CM %]38 is not blank If all 4 criteria are met, then YES, otherwise NO. Of the cells referenced above, only [NPS %]38…
-
filling columns -has to be a better way!
I have a schedule with close to 2000 lines. I am adding columns that need calculations in them. It currently takes me close to 15 min to either drag the formula down or copy and paste chunks. When I create the column why not provide me an option to enter the formula then and apply that to every row? Smartsheets has been…
-
Parent Row Symbols based on highest priority?
It is possible to create a formula that will change the symbol to represent the HIGHEST level out of the 4 rows? IF the (HIGHEST) Risk Level for rows 1-4 is "x" THEN action for symbol column is "low" = blue symbol is "medium" = green symbol is "high" = yellow symbol is "extreme" = red symbol I currently have a formula to…