-
show last comment in Cell
is there any way to define command for cell to see the last comment in the cell it will improve the tracking Tasks , to see in front the last comment in the SS and not go enter to the comment in advance … to enter the comment in cell and log it direct to the comment log\screen
-
E-mail notifications
Hi, I have a 'Sheet' named 'Main sheet' with forms submissions arriving all the time, within the 'Main sheet' there is a field called 'Employee Department', when populated from the form this looks up the 'Project Sponsor' from a further 'Sheet' named 'Lookup' and pulls the e-mail through to the 'Main sheet' - this all…
-
Alerts For When Nearing 5000 row Limit
Is there a way to set up an alert on a sheet for when it is nearing the 5000-row limit? Thanks!
-
Formula to look across rows and columns in a table.
Hi there I need a formula that will look across rows and columns in a table. For example, I need the result for School District-B with 23 items. The result from the table below should populate with: $350 1-5 6-15 16-25 26-50 51-100 100-50000 School District-A $100 $200 $300 $400 $500 $600 School District-B $150 $250 $350…
-
Alert when there is no attachment
Is there a way to send an alert when a record has no attachment? I have a sheet with checkboxes indicating documents have been attached. I want to get an alert if someone checks the box, but forgets to add the attachment. Anyone have any thoughts on how I could do this?
-
Allocating the % of the time can be worked during the day
I am trying to allocate the time that the employee can use for that task during the day to smartsheet. How can I for example if employee has 8 hours of work to do on one task, but he can only spend 50% of his day to this task. This means it will take him 2 days instead of 1 day since he can only work for 4 hours a day. How…
-
Variations of Forms Recently
Hello, We use the form function for all of our production orders everyday and recently, the form has been flip flopping between two different layouts. One is where there is the capability to upload multiple documents at a time and one where you cannot. Is Smartsheet doing some sort of testing or updates? Appreciate any…
-
Renaming Reports - updateReport() functionality
There has been very little discussion on this topic. What is required to get this feature added to the API? I have been assigned the task of creating a JAVA app that will create new workspacea from a set of templates we've created. This is to be done through the JAVA API(SDK). I've completed the app other than renaming the…
-
Email Comparison Formula Needed
Hello Community, I am looking for some help with an email IF Statement and a formula to more information, when a match is detected. I have a couple sets of 3 columns each: Email, First, Last and I need to compare Email with other sets of Emails. NOTE: The 2nd or 3rd or 4th set of Email, First, Last will not have First and…
-
Vlookup limitation of 25000 cells
Can anyone help me to rectify the error as I am using cross sheet vlookup function in Smartsheet to extract some information, while doing this I am facing the error that we can only reference a total of 25000 cells. Is there any way If we want to update multiple columns with the help of other sheet just to avoid the manual…
