-
Can't Set Column Formula for Duration - Work Around Available?
I have several sheets that are tracking the time a field employee is working at a specific location. This is determined by the Current Date minus Start Date to give me the number of days. I set the output column to be a Duration column so that it would automatically input the "d" at the end. For my purposes, this needs to…
-
Is there a way to create a search box?
We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is this possible?
-
Unable to create cross-sheet references
The system shows a message "Unable to create cross-sheet references because this sheet already contains the maximum number of different cross sheet references" . How many references we can do? I am using a sheet that has information of 13 sheets combine. (like a summary sheet). I like the summary sheet but the information…
-
Alert Workflow removing external link
Hi there, This may be a silly question as im just wrapping my head around smartsheet capabilities, however i have an alert workflow which triggers and the main goal is to provide a link to the correct sales landing page in my external website. As seen in the screenshots below i have created a dynamic link within the sheet…
-
Is it possible to reset only a part of the baseline date during the project ?
Regarding the start date /end date baseline function, I'm wondering if it is possible to reset the baseline date just for a part of my planning. For example, if I plan my baseline at the start of my project for every task and I activated the baseline function, and in the realization phase, the baseline of only one task…
-
I need help merging 2 accounts
I currently have a paid business account through my employer, but I have recently discovered I have 2 accounts that need to be merged. I realize this is not an "application" question, but a back office one. However, I have not located where I can submit a ticket or chat with someone that can help.
-
Unable to transfer ownership of specific Smartsheet items
I used to be able to click share for a specific sheet and make someone a owner of a specific document. A few weeks back, the "Make Owner" option stopped showing up. Is there a reason this option was removed and what is the workaround?
-
Whats the formula to find todays date between a range of dates to provide a value?
i need a formula to find todays date between the start date and end date, then provide the current sprint
-
Time Spent /Formula
Hello, I want to calculate the total time spent by each user to then create a graph. I tried a formula but it does not work. Can you help?
-
What licensing is required for collaborators, commenters etc please?
Hi, I have searched but can't find a definitive answer. If I create a project plan in Smartsheet and want people to comment, update or collaborate in general, which of those need a paid license please? To clarify, in this scenario the creator of the plan would have a business license. Many thanks.