-
Formula to display Red Flags
I am attempting to have a RED Flag populate in the "Risk" Column for cells where the "Available Space" is less than 10. Kindly when answering, please complete the entire formula from start to end as from research I tend to get bits and pieces as seen in my screenshot. Thanks,
-
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…
