-
Index/Collect with Specific Criteria
I am trying to automatically populate the Parent "Content Development Status" column based on the most recent "Child" in the "Tasks" column, but there are certain Children rows in the Task column that I want to ignore. For example, if there is a webinar delivered, I do not want this to populate in the Content Development…
-
Using Reference Sheet to toggle Checkbox
Hello, I've been digging and digging through Smartsheet posts and other references and cannot seem to find a comparable reference to use for my use case. I have 2 sheets. The first sheet stores PMs for equipment inspections. There is a column for "Equipment Name" and a column "PM Date". The second sheet has a column for…
-
Nonsense letters - Mapping PDF doesn't pull information from form/sheet correctly
I am trying to use the entries from a form to auto-generate certificates of completion. It seems I have everything set up correctly (Fillable PDF mapped, set up in the workflow, correct column naming etc), however it generates nonsense letters for the entries. Any ideas on what I should troubleshoot to fix this?
-
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?
-
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…
-
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?
-
Merged: Make the Undo Button Active
This discussion has been merged.
-
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