-
How to use formula from source to destination sheet?
Hi Team, I have 2 source sheets, I need to add values from those two sheets where month is equal to "September" and so on.. Anyone kindly help me on this. Thanks, Sandhiya P
-
Notification Trigger 44 Weeks After Date
Hello, I'm trying to set up an automatic notification for training reminders without using helper columns. I'd like to set up the trigger date as 335 days after a specific date (4 weeks before they need to renew). For example, if they renewed their training on September 28, 2020 then they would get a reminder notice on…
-
Disappearing icon bar in Chrome
Anybody know why the Smartsheet icon bar would disappear in Chrome? This has happened more than once, so it appears to be a bug. The only thing that fixes it is to close the browser tab and re-open the sheet in a new tab. Here is what it looks like when it happens: BEFORE: AFTER: I have not seen this behavior happen in…
-
Please add admin ability to force password resets
Forcing the reset of a user's password is critical to the security and efficiency of any user management system. Every other web service I can think of that uses an admin/multi-user structure has such a feature. Here are some examples where a forced password reset would be not only useful but dramatically affect the…
-
Exporting Smartsheet to CSV (for JIRA import) without losing our comments
We have a team using Smartsheet that will be moving to JIRA in the coming months. I have seen here that one my export a Sheet as an Excel file, but the comments come on a second tab. In order to import this to JIRA, it will need to be in CSV format which can only support one tab.…
-
SUMIFS with multiple OR criterion
Hello there, I am using the function : SUMIFS( range, criterion_range1, criterion1, [ criterion_range2, criterion2... ]) How can I have multiple values for criterion1? I mean, I have multiple values which any one of them will satisfy the requirement, and I want to add all. E.g. I have a list of many names (in another…
-
Show schedule gaps in parent Gantt View
Hello, Is there any way to show the gaps in the schedules for child tasks in the Gantt view. Currently, the parent shows the minimum and maximum dates of the child and displays a continuous graphic, even if there are gaps in the schedule of the child tasks. Can anything be done to display these schedule gaps in the parent…
-
Is it possible to stop a flow pulling in a duplicate line item
Hi all, Hope you are all well! With the help of this community i have created a form that will automatically identify how a line item and how long it is before being cancelled. This form will then send emails to Project Managers once we are 5 days away from cancellation and then a day away. Because of this, we are going to…
-
How to set up a field with multiple entries in a form?
I need to create a field that has multiple entries in a form. I prefer not to create several columns (I need the respondents to make 7 entries, hence 7 columns should be created). Does anyone have a suggestion on how to do that?
-
Need help ASAP on this
Whenever a new otb number is added it should capture it when you select otb number show new otb number as a choice and take you to the url link of that otb number only. I am asking on how exactly would I configure this without having to add manuel filters by whenever I enter in a new OTB number in the smartsheets it will…
