-
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…
-
V-axis showing 0 and 1 instead of %
In my chart, I am displaying %, and the chart is showing that in Series -> Data Labels, but the vertical axis is showing only "0" and "1". I would like the vertical axis to show the values given, those between 0 and 1, as a %. Your help is appreciated. Thank you.
-
Webform Submission issue
We are currently using our own custom WebForm to submit directly to Smartsheet. This process has been working flawlessly for the last few months. We had had users reporting now that when they hit submit on our php WebForm the old Smartsheet WebForm pops up and is completely blank. However if we go into Smartsheet, all the…
