-
Update VIA API not showing updates
Hello There Super Noob to Smartsheet APIs. I am updating smartsheet, with Powershell, a Test Sheet sending simple sample data. It shows that I have added multiple row, in the test sheet, but it isn't showing the data even if I refresh the sheet. I have no Idea whats going on.
-
Using SUMIF to provide value of orders from this week only
Hi, I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value. =SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value}) The sheet references are to single columns titled 'Completion Date' and 'Order Value'…
-
Smartsheet limitations when collaborating with multiple teams
I've been using Smartsheet for a few years now, but recently we have been rolling it out for more serious applications involving collaboration between multiple teams, including external teams and we seem to have come accross a fundamental limitation of Smartsheets, that being the permissions model. For a platform whose…
-
Selectable Drop Down Menus For Web Forms
Is it possible to create drop down menus within web forms? I am looking for a way to have limited selections for each question which does not allow the submitter to create discrepancies. Thanks!
-
Can you have a character limit in a Web Form text box?
Is it possible to have a character limit in a text box within a Web Form? We've limited the number of lines to three, but would rather limit to a specific character count. Appreciate any insight!
-
COUNTIF or COUNTIFS
I think I have formulated myself into a corner. What I am attempting to do is create a total number of all open projects based on the multiple status options in 5 separate columns. So, if the data in columns Stats1:Stats5 match X or Y or X, return that total count. I am able to do this for One…
-
Alert on date expiring
Kia ora everyone, Couldn't find anything relating to this question, but feel it can't be the first time asked :-) I'd like to have an alert on a date column, so that 30 days prior to that date we are notified. Is this possible? Thanks, Brendon
-
return list from another sheet
Anyone able to offer some help on the formula below - trying to return a list of information relative to an employee ID number to a column. There will be several matches per ID, e.g. Matt worked item 1.. 2... 3.. and 7. I want to return the information relative to that ID for those entries. Thanks in advance!…
-
How to easily capture Actual Time spent on a Task in SmartSheet?
Fellow SmartSheet Community Members, We have recently started using SmartSheet for planning out a roadmap for initiatives, along with types of roles allocated to the initiative (resources) as well as allocation. We are now looking for creative ways to capture "Actual" time spent on a particular initiative. Here are our…
-
Formula to mesasure running time
Hi everyone, I need help on the following topic. I am trying to create a formula to show (measure) the running time in days between the column "done" and the column "creation date"? (see attached image). Thanks for your feedback