-
JOIN-COLLECT and Contact
Hello, I am trying to use JOIN-COLLECT to populate a cell with a contact by pulling from another sheet. However, when I use this formula it populates the cell with the name of the contact as a text string, but does not populate the cell with the contact itself. Both the column of cells being populated and the column the…
-
How to set up the Open request link to open in a new tab?
A coworker asked me to investigate why, when she clicks Open request in a Smartsheet email notification, it doesn’t open in a new tab. When I click the same link, it opens in a new tab without issue. I’m using Microsoft Edge, and she’s using Google Chrome.
-
Dynamic View Predetermined Fields
I have a form that is completed by 16 different entities for 57 unique roles, filling a master sheet. I want to utilize the Dynamic View function, but also have prefilled fields and use a MATCH function from the master sheet to the dynamic view to match the input to the unique roles. The purpose is that there are a finite…
-
Budget Management
All I wanted to show you how I am using smartsheet to keep my budget reporting in real-time. I have 3 sheets 1) A Budget sheet 2) An Invoice Sheet 3) A Project Action Log The purposes are as follows Budget sheet This houses my line my approved budget using MasterFormat and also my Non-construction costs like Architect…
-
Smartsheet Employee Dashboard functioning like an app
Hi there I have created a Smartsheet Dashboard for each employee, with sheet visual icons related to their worksheets. It serves as a quick link and hosts only the sheets they need to access and work on. The Icons are categorised as per our company's production and accountability structures. It resulted in no further…
-
Edit Forms on the Smartsheet App
There aren’t many times I used the iOS application it‘s just simply not there at all or close, can we get more from the mobile site or the app to be able to edit forms quickly on the fly? I have a form I need to make a small adjustment too or even copy and change up.
-
Use the internal row id
We manually add the internal rowID to a new row by selecting the row properties, copying and pasting it into a field. Then a URL is calculated to provide a link to that specific row. It would be helpful if there would be a way we could generate a hyperlink but access the rowID directly something like:…
-
Unhide specific columns on a sheet
Instead of unhiding all columns to find one or two that are needed, it'd be great to be able to unhide specific ones, like Excel does with Tabs.
-
Merged: Allow comments to locked rows or allow for locked calls vs rows
This discussion has been merged.
-
El campo % de avance lo edito pero se cambia en automatico a otros valores
Buena tarde necesito apoyo. En mi columna de avance porcentual solo puedo manejar 0%, 70% y 100% cuando pongo cualquier otro valor en automatico me lo cambia a 70%, este sheet no lo cree yo, y ya busque en sus configuraciones y nada. Ojala me puedan ayudar, ¡Saludos!